SqlDWSinkResponse

data class SqlDWSinkResponse(val allowCopyCommand: Any? = null, val allowPolyBase: Any? = null, val copyCommandSettings: DWCopyCommandSettingsResponse? = null, val disableMetricsCollection: Any? = null, val maxConcurrentConnections: Any? = null, val polyBaseSettings: PolybaseSettingsResponse? = null, val preCopyScript: Any? = null, val sinkRetryCount: Any? = null, val sinkRetryWait: Any? = null, val sqlWriterUseTableLock: Any? = null, val tableOption: Any? = null, val type: String, val upsertSettings: SqlDWUpsertSettingsResponse? = null, val writeBatchSize: Any? = null, val writeBatchTimeout: Any? = null, val writeBehavior: Any? = null)

A copy activity SQL Data Warehouse sink.

Constructors

Link copied to clipboard
constructor(allowCopyCommand: Any? = null, allowPolyBase: Any? = null, copyCommandSettings: DWCopyCommandSettingsResponse? = null, disableMetricsCollection: Any? = null, maxConcurrentConnections: Any? = null, polyBaseSettings: PolybaseSettingsResponse? = null, preCopyScript: Any? = null, sinkRetryCount: Any? = null, sinkRetryWait: Any? = null, sqlWriterUseTableLock: Any? = null, tableOption: Any? = null, type: String, upsertSettings: SqlDWUpsertSettingsResponse? = null, writeBatchSize: Any? = null, writeBatchTimeout: Any? = null, writeBehavior: Any? = null)

Types

Link copied to clipboard
object Companion

Properties

Link copied to clipboard
val allowCopyCommand: Any? = null

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

Link copied to clipboard
val allowPolyBase: Any? = null

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

Link copied to clipboard

Specifies Copy Command related settings when allowCopyCommand is true.

Link copied to clipboard

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

Link copied to clipboard

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

Link copied to clipboard

Specifies PolyBase-related settings when allowPolyBase is true.

Link copied to clipboard
val preCopyScript: Any? = null

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

Link copied to clipboard
val sinkRetryCount: Any? = null

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

Link copied to clipboard
val sinkRetryWait: Any? = null

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

Link copied to clipboard

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

Link copied to clipboard
val tableOption: Any? = null

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

Link copied to clipboard

Copy sink type. Expected value is 'SqlDWSink'.

Link copied to clipboard

SQL DW upsert settings.

Link copied to clipboard
val writeBatchSize: Any? = null

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

Link copied to clipboard
val writeBatchTimeout: Any? = null

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

Link copied to clipboard
val writeBehavior: Any? = null

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