SqlDWSink Constructors

Definition

Namespace:

Microsoft.Azure.Management.DataFactory.Models

Assembly:

Microsoft.Azure.Management.DataFactory.dll

Package:

Microsoft.Azure.Management.DataFactory v8.0.0

Overloads

SqlDWSink()	Initializes a new instance of the SqlDWSink class.
SqlDWSink(IDictionary<String,Object>, Object, Object, Object, Object, Object, Object, Object, Object, PolybaseSettings, Object, DWCopyCommandSettings, Object, Object, Object, SqlDWUpsertSettings)	Initializes a new instance of the SqlDWSink class.

SqlDWSink()

Initializes a new instance of the SqlDWSink class.

public SqlDWSink ();

Public Sub New ()

SqlDWSink(IDictionary<String,Object>, Object, Object, Object, Object, Object, Object, Object, Object, PolybaseSettings, Object, DWCopyCommandSettings, Object, Object, Object, SqlDWUpsertSettings)

Initializes a new instance of the SqlDWSink class.

public SqlDWSink (System.Collections.Generic.IDictionary<string,object> additionalProperties = default, object writeBatchSize = default, object writeBatchTimeout = default, object sinkRetryCount = default, object sinkRetryWait = default, object maxConcurrentConnections = default, object disableMetricsCollection = default, object preCopyScript = default, object allowPolyBase = default, Microsoft.Azure.Management.DataFactory.Models.PolybaseSettings polyBaseSettings = default, object allowCopyCommand = default, Microsoft.Azure.Management.DataFactory.Models.DWCopyCommandSettings copyCommandSettings = default, object tableOption = default, object sqlWriterUseTableLock = default, object writeBehavior = default, Microsoft.Azure.Management.DataFactory.Models.SqlDWUpsertSettings upsertSettings = default);

new Microsoft.Azure.Management.DataFactory.Models.SqlDWSink : System.Collections.Generic.IDictionary<string, obj> * obj * obj * obj * obj * obj * obj * obj * obj * Microsoft.Azure.Management.DataFactory.Models.PolybaseSettings * obj * Microsoft.Azure.Management.DataFactory.Models.DWCopyCommandSettings * obj * obj * obj * Microsoft.Azure.Management.DataFactory.Models.SqlDWUpsertSettings -> Microsoft.Azure.Management.DataFactory.Models.SqlDWSink

Public Sub New (Optional additionalProperties As IDictionary(Of String, Object) = Nothing, Optional writeBatchSize As Object = Nothing, Optional writeBatchTimeout As Object = Nothing, Optional sinkRetryCount As Object = Nothing, Optional sinkRetryWait As Object = Nothing, Optional maxConcurrentConnections As Object = Nothing, Optional disableMetricsCollection As Object = Nothing, Optional preCopyScript As Object = Nothing, Optional allowPolyBase As Object = Nothing, Optional polyBaseSettings As PolybaseSettings = Nothing, Optional allowCopyCommand As Object = Nothing, Optional copyCommandSettings As DWCopyCommandSettings = Nothing, Optional tableOption As Object = Nothing, Optional sqlWriterUseTableLock As Object = Nothing, Optional writeBehavior As Object = Nothing, Optional upsertSettings As SqlDWUpsertSettings = Nothing)

Parameters

additionalProperties

IDictionary<String,Object>

Unmatched properties from the message are deserialized this collection

writeBatchSize

Object

Write batch size. Type: integer (or Expression with resultType integer), minimum: 0.

writeBatchTimeout

Object

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

sinkRetryCount

Object

Sink retry count. Type: integer (or Expression with resultType integer).

sinkRetryWait

Object

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

maxConcurrentConnections

Object

The maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer).

disableMetricsCollection

Object

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

preCopyScript

Object

SQL pre-copy script. Type: string (or Expression with resultType string).

allowPolyBase

Object

Indicates to use PolyBase to copy data into SQL Data Warehouse when applicable. Type: boolean (or Expression with resultType boolean).

polyBaseSettings

PolybaseSettings

Specifies PolyBase-related settings when allowPolyBase is true.

allowCopyCommand

Object

Indicates to use Copy Command to copy data into SQL Data Warehouse. Type: boolean (or Expression with resultType boolean).

copyCommandSettings

DWCopyCommandSettings

Specifies Copy Command related settings when allowCopyCommand is true.

tableOption

Object

The option to handle sink table, such as autoCreate. For now only 'autoCreate' value is supported. Type: string (or Expression with resultType string).

sqlWriterUseTableLock

Object

Whether to use table lock during bulk copy. Type: boolean (or Expression with resultType boolean).

writeBehavior

Object

Write behavior when copying data into azure SQL DW. Type: SqlDWWriteBehaviorEnum (or Expression with resultType SqlDWWriteBehaviorEnum)

upsertSettings

SqlDWUpsertSettings

SQL DW upsert settings.