SqlDWSink Class
A copy activity SQL Data Warehouse sink.
All required parameters must be populated in order to send to server.
- Inheritance
-
azure.mgmt.datafactory.models._models_py3.CopySinkSqlDWSink
Constructor
SqlDWSink(*, additional_properties: Dict[str, MutableMapping[str, Any]] | None = None, write_batch_size: MutableMapping[str, Any] | None = None, write_batch_timeout: MutableMapping[str, Any] | None = None, sink_retry_count: MutableMapping[str, Any] | None = None, sink_retry_wait: MutableMapping[str, Any] | None = None, max_concurrent_connections: MutableMapping[str, Any] | None = None, disable_metrics_collection: MutableMapping[str, Any] | None = None, pre_copy_script: MutableMapping[str, Any] | None = None, allow_poly_base: MutableMapping[str, Any] | None = None, poly_base_settings: _models.PolybaseSettings | None = None, allow_copy_command: MutableMapping[str, Any] | None = None, copy_command_settings: _models.DWCopyCommandSettings | None = None, table_option: MutableMapping[str, Any] | None = None, sql_writer_use_table_lock: MutableMapping[str, Any] | None = None, write_behavior: MutableMapping[str, Any] | None = None, upsert_settings: _models.SqlDWUpsertSettings | None = None, **kwargs: Any)Keyword-Only Parameters
| Name | Description |
|---|---|
|
additional_properties
|
Unmatched properties from the message are deserialized to this collection. |
|
write_batch_size
|
<xref:JSON>
Write batch size. Type: integer (or Expression with resultType integer), minimum: 0. |
|
write_batch_timeout
|
<xref:JSON>
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
|
<xref:JSON>
Sink retry count. Type: integer (or Expression with resultType integer). |
|
sink_retry_wait
|
<xref:JSON>
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
|
<xref:JSON>
The maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer). |
|
disable_metrics_collection
|
<xref:JSON>
If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean). |
|
pre_copy_script
|
<xref:JSON>
SQL pre-copy script. Type: string (or Expression with resultType string). |
|
allow_poly_base
|
<xref:JSON>
Indicates to use PolyBase to copy data into SQL Data Warehouse when applicable. Type: boolean (or Expression with resultType boolean). |
|
poly_base_settings
|
Specifies PolyBase-related settings when allowPolyBase is true. |
|
allow_copy_command
|
<xref:JSON>
Indicates to use Copy Command to copy data into SQL Data Warehouse. Type: boolean (or Expression with resultType boolean). |
|
copy_command_settings
|
Specifies Copy Command related settings when allowCopyCommand is true. |
|
table_option
|
<xref:JSON>
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
|
<xref:JSON>
Whether to use table lock during bulk copy. Type: boolean (or Expression with resultType boolean). |
|
write_behavior
|
<xref:JSON>
Write behavior when copying data into azure SQL DW. Type: SqlDWWriteBehaviorEnum (or Expression with resultType SqlDWWriteBehaviorEnum). |
|
upsert_settings
|
SQL DW upsert settings. |
Variables
| Name | Description |
|---|---|
|
additional_properties
|
Unmatched properties from the message are deserialized to this collection. |
|
type
|
Copy sink type. Required. |
|
write_batch_size
|
<xref:JSON>
Write batch size. Type: integer (or Expression with resultType integer), minimum: 0. |
|
write_batch_timeout
|
<xref:JSON>
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
|
<xref:JSON>
Sink retry count. Type: integer (or Expression with resultType integer). |
|
sink_retry_wait
|
<xref:JSON>
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
|
<xref:JSON>
The maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer). |
|
disable_metrics_collection
|
<xref:JSON>
If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean). |
|
pre_copy_script
|
<xref:JSON>
SQL pre-copy script. Type: string (or Expression with resultType string). |
|
allow_poly_base
|
<xref:JSON>
Indicates to use PolyBase to copy data into SQL Data Warehouse when applicable. Type: boolean (or Expression with resultType boolean). |
|
poly_base_settings
|
Specifies PolyBase-related settings when allowPolyBase is true. |
|
allow_copy_command
|
<xref:JSON>
Indicates to use Copy Command to copy data into SQL Data Warehouse. Type: boolean (or Expression with resultType boolean). |
|
copy_command_settings
|
Specifies Copy Command related settings when allowCopyCommand is true. |
|
table_option
|
<xref:JSON>
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
|
<xref:JSON>
Whether to use table lock during bulk copy. Type: boolean (or Expression with resultType boolean). |
|
write_behavior
|
<xref:JSON>
Write behavior when copying data into azure SQL DW. Type: SqlDWWriteBehaviorEnum (or Expression with resultType SqlDWWriteBehaviorEnum). |
|
upsert_settings
|
SQL DW upsert settings. |
Azure SDK for Python