Dela via


SqlPartitionSettings Class

Definition

The settings that will be leveraged for Sql source partitioning.

public class SqlPartitionSettings
type SqlPartitionSettings = class
Public Class SqlPartitionSettings
Inheritance
SqlPartitionSettings

Constructors

SqlPartitionSettings()

Initializes a new instance of the SqlPartitionSettings class.

SqlPartitionSettings(Object, Object, Object)

Initializes a new instance of the SqlPartitionSettings class.

Properties

PartitionColumnName

Gets or sets 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

Gets or sets 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

Gets or sets 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