AzureSqlSink Class

A copy activity Azure SQL sink.

All required parameters must be populated in order to send to Azure.

Inheritance

azure.mgmt.datafactory.models._models_py3.CopySink

AzureSqlSink

Constructor

AzureSqlSink(*, additional_properties: Optional[Dict[str, Any]] = None, write_batch_size: Optional[Any] = None, write_batch_timeout: Optional[Any] = None, sink_retry_count: Optional[Any] = None, sink_retry_wait: Optional[Any] = None, max_concurrent_connections: Optional[Any] = None, disable_metrics_collection: Optional[Any] = None, sql_writer_stored_procedure_name: Optional[Any] = None, sql_writer_table_type: Optional[Any] = None, pre_copy_script: Optional[Any] = None, stored_procedure_parameters: Optional[Dict[str, _models.StoredProcedureParameter]] = None, stored_procedure_table_type_parameter_name: Optional[Any] = None, table_option: Optional[Any] = None, sql_writer_use_table_lock: Optional[Any] = None, write_behavior: Optional[Any] = None, upsert_settings: Optional[_models.SqlUpsertSettings] = None, **kwargs)

Variables

additional_properties

dict[str, any]

Unmatched properties from the message are deserialized to this collection.

type

str

Required. Copy sink type.Constant filled by server.

write_batch_size

any

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

write_batch_timeout

any

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

any

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

sink_retry_wait

any

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

any

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

disable_metrics_collection

any

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

sql_writer_stored_procedure_name

any

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

sql_writer_table_type

any

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

pre_copy_script

any

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

stored_procedure_parameters

dict[<xref:str,azure.mgmt.datafactory.models.StoredProcedureParameter>]

SQL stored procedure parameters.

stored_procedure_table_type_parameter_name

any

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

table_option

any

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

any

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

write_behavior

any

Write behavior when copying data into Azure SQL. Type: SqlWriteBehaviorEnum (or Expression with resultType SqlWriteBehaviorEnum).

upsert_settings

SqlUpsertSettings

SQL upsert settings.