Azure
A copy activity Azure SQL sink.
Constructors
Properties
If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).
The maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer).
SQL pre-copy script. Type: string (or Expression with resultType string).
Sink retry count. Type: integer (or Expression with resultType integer).
Sink retry wait. Type: string (or Expression with resultType string), pattern: ((\d+)\.)?(\d\d):(60|(0-9)):(60|(0-9)).
SQL writer stored procedure name. Type: string (or Expression with resultType string).
SQL writer table type. Type: string (or Expression with resultType string).
Whether to use table lock during bulk copy. Type: boolean (or Expression with resultType boolean).
SQL stored procedure parameters.
The stored procedure parameter name of the table type. Type: string (or Expression with resultType string).
The option to handle sink table, such as autoCreate. For now only 'autoCreate' value is supported. Type: string (or Expression with resultType string).
SQL upsert settings.
Write batch size. Type: integer (or Expression with resultType integer), minimum: 0.
Write batch timeout. Type: string (or Expression with resultType string), pattern: ((\d+)\.)?(\d\d):(60|(0-9)):(60|(0-9)).
Write behavior when copying data into Azure SQL. Type: SqlWriteBehaviorEnum (or Expression with resultType SqlWriteBehaviorEnum)