Sql
A copy activity SQL Data Warehouse sink.
Constructors
Properties
Indicates to use Copy Command to copy data into SQL Data Warehouse. Type: boolean (or Expression with resultType boolean).
Indicates to use PolyBase to copy data into SQL Data Warehouse when applicable. Type: boolean (or Expression with resultType boolean).
Specifies Copy Command related settings when allowCopyCommand is true.
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).
Specifies PolyBase-related settings when allowPolyBase is true.
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)).
Whether to use table lock during bulk copy. Type: boolean (or Expression with resultType boolean).
The option to handle sink table, such as autoCreate. For now only 'autoCreate' value is supported. Type: string (or Expression with resultType string).
SQL DW 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 DW. Type: SqlDWWriteBehaviorEnum (or Expression with resultType SqlDWWriteBehaviorEnum)