Sdílet prostřednictvím


SqlDWSource Class

Definition

A copy activity SQL Data Warehouse source.

public class SqlDWSource : Microsoft.Azure.Management.DataFactory.Models.TabularSource
type SqlDWSource = class
    inherit TabularSource
Public Class SqlDWSource
Inherits TabularSource
Inheritance

Constructors

SqlDWSource()

Initializes a new instance of the SqlDWSource class.

SqlDWSource(IDictionary<String,Object>, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, SqlPartitionSettings)

Initializes a new instance of the SqlDWSource class.

Properties

AdditionalColumns

Gets or sets specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).

(Inherited from TabularSource)
AdditionalProperties

Gets or sets unmatched properties from the message are deserialized this collection

(Inherited from CopySource)
DisableMetricsCollection

Gets or sets if true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).

(Inherited from CopySource)
MaxConcurrentConnections

Gets or sets the maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer).

(Inherited from CopySource)
PartitionOption

Gets or sets the partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange".

PartitionSettings

Gets or sets the settings that will be leveraged for Sql source partitioning.

QueryTimeout

Gets or sets query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

(Inherited from TabularSource)
SourceRetryCount

Gets or sets source retry count. Type: integer (or Expression with resultType integer).

(Inherited from CopySource)
SourceRetryWait

Gets or sets source retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

(Inherited from CopySource)
SqlReaderQuery

Gets or sets SQL Data Warehouse reader query. Type: string (or Expression with resultType string).

SqlReaderStoredProcedureName

Gets or sets name of the stored procedure for a SQL Data Warehouse source. This cannot be used at the same time as SqlReaderQuery. Type: string (or Expression with resultType string).

StoredProcedureParameters

Gets or sets value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}". Type: object (or Expression with resultType object), itemType: StoredProcedureParameter.

Applies to