SqlDWSink Constructors

  • Reference

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 ()

Applies to

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.

Applies to