Udostępnij za pośrednictwem


SqlDWSink Class

Definition

A copy activity SQL Data Warehouse sink.

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

Constructors

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.

Properties

AdditionalProperties

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

(Inherited from CopySink)
AllowCopyCommand

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

AllowPolyBase

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

CopyCommandSettings

Gets or sets specifies Copy Command related settings when allowCopyCommand is true.

DisableMetricsCollection

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

(Inherited from CopySink)
MaxConcurrentConnections

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

(Inherited from CopySink)
PolyBaseSettings

Gets or sets specifies PolyBase-related settings when allowPolyBase is true.

PreCopyScript

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

SinkRetryCount

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

(Inherited from CopySink)
SinkRetryWait

Gets or sets sink 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 CopySink)
SqlWriterUseTableLock

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

TableOption

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

UpsertSettings

Gets or sets SQL DW upsert settings.

WriteBatchSize

Gets or sets write batch size. Type: integer (or Expression with resultType integer), minimum: 0.

(Inherited from CopySink)
WriteBatchTimeout

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

(Inherited from CopySink)
WriteBehavior

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

Applies to