AzureSqlSinkResponse

data class AzureSqlSinkResponse(val disableMetricsCollection: Any? = null, val maxConcurrentConnections: Any? = null, val preCopyScript: Any? = null, val sinkRetryCount: Any? = null, val sinkRetryWait: Any? = null, val sqlWriterStoredProcedureName: Any? = null, val sqlWriterTableType: Any? = null, val sqlWriterUseTableLock: Any? = null, val storedProcedureParameters: Any? = null, val storedProcedureTableTypeParameterName: Any? = null, val tableOption: Any? = null, val type: String, val upsertSettings: SqlUpsertSettingsResponse? = null, val writeBatchSize: Any? = null, val writeBatchTimeout: Any? = null, val writeBehavior: Any? = null)

A copy activity Azure SQL sink.

Constructors

Link copied to clipboard
constructor(disableMetricsCollection: Any? = null, maxConcurrentConnections: Any? = null, preCopyScript: Any? = null, sinkRetryCount: Any? = null, sinkRetryWait: Any? = null, sqlWriterStoredProcedureName: Any? = null, sqlWriterTableType: Any? = null, sqlWriterUseTableLock: Any? = null, storedProcedureParameters: Any? = null, storedProcedureTableTypeParameterName: Any? = null, tableOption: Any? = null, type: String, upsertSettings: SqlUpsertSettingsResponse? = null, writeBatchSize: Any? = null, writeBatchTimeout: Any? = null, writeBehavior: Any? = null)

Types

Link copied to clipboard
object Companion

Properties

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

SQL writer stored procedure name. Type: string (or Expression with resultType string).

Link copied to clipboard
val sqlWriterTableType: Any? = null

SQL writer table type. Type: string (or Expression with resultType string).

Link copied to clipboard

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

Link copied to clipboard

SQL stored procedure parameters.

Link copied to clipboard

The stored procedure parameter name of the table type. Type: string (or Expression with resultType string).

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 'AzureSqlSink'.

Link copied to clipboard

SQL 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. Type: SqlWriteBehaviorEnum (or Expression with resultType SqlWriteBehaviorEnum)