Adf Azure Sql Data Warehouse Sink Element
X-Ref:
- Ast Adf Azure Sql Data Warehouse Sink Node
- Ast Adf Pre Copy Script Sink Base Node
- Ast Adf Dataset Sink Base Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| DatasetName | AstAdfAzureSqlDataWarehouseDatasetNode | Specifies a reference to the AzureSqlDataWarehouse dataset that will receive the data. This is a required reference to an existing definiton. | |
| CopyMethod | AdfSynapseSinkCopyMethod | BulkInsert | Specifies a whether or not to use PolyBase, Copy Command, or BulkInsert for Azure SQL Data Warehouse dataset sinks. The default value is BulkInsert. |
| MaxConcurrentConnections | Int32 | 0 | Max number of simultaneous connections to the source. |
| RetryCount | Int32 | 0 | Number of retries. |
| RetryWait | String | String representing the retry wait. Pattern: ((\\d+)\\.)?(\\d\\d):(60|([0-5][0-9])):(60|([0-5][0-9])) | |
| WriteBatchSize | Int32 | -1 | Specifies the number of rows that should be stored in the write buffer before sending to the sink dataset. |
| WriteBatchTimeout | String | Specifies the timespan that the activity should wait for the sink dataset before raising an error. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <PolyBaseSettings /> | AstAdfPolyBaseSettingsNode | AstAdfPolyBaseSettingsNode objects correspond directly to Copy Activity sink settings for Azure Sql Data Warehouse datasets that use the polybase mechanism in Azure Data Factory. |
| <CopyCommandSettings /> | AstAdfCopyCommandSettingsNode | AstAdfCopyCommandSettingsNode objects correspond directly to Copy Activity sink settings for Azure Sql Data Warehouse datasets that use the copy command mechanism in Azure Data Factory. |
| <PreCopyScript /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
| <Parameters> <Parameter /> </Parameters> | AstAdfCopyActivityParameterNode | Specifies the Dataset parameters to be used. |