Share via


SqlPartitionSettings Class

Definition

The settings that will be leveraged for Sql source partitioning.

[System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.SqlPartitionSettings+SqlPartitionSettingsConverter))]
public class SqlPartitionSettings
[<System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.SqlPartitionSettings+SqlPartitionSettingsConverter))>]
type SqlPartitionSettings = class
Public Class SqlPartitionSettings
Inheritance
SqlPartitionSettings
Attributes

Constructors

SqlPartitionSettings()

Initializes a new instance of SqlPartitionSettings.

Properties

PartitionColumnName

The name of the column in integer or datetime type that will be used for proceeding partitioning. If not specified, the primary key of the table is auto-detected and used as the partition column. Type: string (or Expression with resultType string).

PartitionLowerBound

The minimum value of the partition column for partition range splitting. This value is used to decide the partition stride, not for filtering the rows in table. All rows in the table or query result will be partitioned and copied. Type: string (or Expression with resultType string).

PartitionUpperBound

The maximum value of the partition column for partition range splitting. This value is used to decide the partition stride, not for filtering the rows in table. All rows in the table or query result will be partitioned and copied. Type: string (or Expression with resultType string).

Applies to