AzureSqlSink Class
A copy activity Azure SQL sink.
Constructor
AzureSqlSink(*args: Any, **kwargs: Any)Variables
| Name | Description |
|---|---|
|
write_batch_size
|
Write batch size. Type: integer (or Expression with resultType integer), minimum: 0. |
|
write_batch_timeout
|
Write batch timeout. Type: string (or Expression with resultType string), pattern: ((d+).)?(dd):(60|([0-5][0-9])):(60|([0-5][0-9])). |
|
sink_retry_count
|
Sink retry count. Type: integer (or Expression with resultType integer). |
|
sink_retry_wait
|
Sink retry wait. Type: string (or Expression with resultType string), pattern: ((d+).)?(dd):(60|([0-5][0-9])):(60|([0-5][0-9])). |
|
max_concurrent_connections
|
The maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer). |
|
disable_metrics_collection
|
If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean). |
|
sql_writer_stored_procedure_name
|
SQL writer stored procedure name. Type: string (or Expression with resultType string). |
|
sql_writer_table_type
|
SQL writer table type. Type: string (or Expression with resultType string). |
|
pre_copy_script
|
SQL pre-copy script. Type: string (or Expression with resultType string). |
|
stored_procedure_parameters
|
SQL stored procedure parameters. |
|
stored_procedure_table_type_parameter_name
|
The stored procedure parameter name of the table type. Type: string (or Expression with resultType string). |
|
table_option
|
The option to handle sink table, such as autoCreate. For now only 'autoCreate' value is supported. Type: string (or Expression with resultType string). |
|
sql_writer_use_table_lock
|
Whether to use table lock during bulk copy. Type: boolean (or Expression with resultType boolean). |
|
write_behavior
|
Write behavior when copying data into Azure SQL. Type: SqlWriteBehaviorEnum (or Expression with resultType SqlWriteBehaviorEnum). |
|
upsert_settings
|
SQL upsert settings. |
|
type
|
Copy sink type. Required. Default value is "AzureSqlSink". |
Attributes
pre_copy_script
string (or Expression with resultType string).
pre_copy_script: Any | Nonesql_writer_stored_procedure_name
string (or Expression with resultType string).
sql_writer_stored_procedure_name: Any | Nonesql_writer_table_type
string (or Expression with resultType string).
sql_writer_table_type: Any | Nonesql_writer_use_table_lock
boolean (or Expression with resultType boolean).
sql_writer_use_table_lock: Any | Nonestored_procedure_parameters
SQL stored procedure parameters.
stored_procedure_parameters: Any | Nonestored_procedure_table_type_parameter_name
string (or Expression with resultType string).
stored_procedure_table_type_parameter_name: Any | Nonetable_option
The option to handle sink table, such as autoCreate. For now only 'autoCreate' value is supported. Type: string (or Expression with resultType string).
table_option: Any | Nonetype
Copy sink type. Required. Default value is "AzureSqlSink".
type: Literal['AzureSqlSink']upsert_settings
SQL upsert settings.
upsert_settings: _models.SqlUpsertSettings | Nonewrite_behavior
SqlWriteBehaviorEnum (or Expression with resultType SqlWriteBehaviorEnum).
write_behavior: Any | None