Adf Fabric Sql Database Sink Element
Adf Fabric Sql Database Sink Element
API Type:
Varigence.Languages.Biml.DataFactory.AstAdfFabricSqlDatabaseSinkNode
X-Ref:
- Ast Adf Fabric Sql Database Sink Node
- Ast Adf Sql Server Database Sink Base Node
- Ast Adf Pre Copy Script Sink Base Node
- Ast Adf Dataset Sink Base Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| DatasetName | AstAdfFabricSqlDatabaseDatasetNode | Specifies a reference to the Microsoft Fabric SQL Database dataset that will receive the data. This is a required reference to an existing definiton. | |
| DisableMetricsCollection | Boolean | False | If true, disable data store metrics collection. Default is false. |
| 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])) | |
| SqlWriterUseTableLock | Boolean | False | Specifies whether to use table lock during bulk copy. |
| StoredProcedure | String | Name of the Stored Procedure that is being used to upsert data into the sink. | |
| StoredProcedureTableTypeParameterName | String | The name of the stored procedure parameter of the table type. | |
| TableOption | String | Specifies the option to handle the sink table, such as autoCreate. For now only the autoCreate value is supported. | |
| TableType | String | Specifies a table type for Stored Procedure usage. Copy activities make moving data available in a temporary table with this specified type. This allows the stored procedure code to merge the data being copied with existing data. | |
| 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. | |
| WriteBehavior | AdfSqlSinkWriteBehavior | Insert | Specifies the write behavior to use when copying data into the sink (Insert, Upsert, or StoredProcedure). The default is Insert. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <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. |
| <RawJsonProperties /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. |
| <UpsertSettings /> | AstAdfSqlUpsertSettingsNode | AstAdfSqlUpsertSettingsNode objects correspond directly to SQL upsert option settings on Copy Activity sinks for SQL Server family datasets in Azure Data Factory. |
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. |
| <StoredProcedureParameters> <Parameter /> </StoredProcedureParameters> | AstAdfStoredProcedureParameterNode | This collection contains the parameters that will be passed to the stored produre for execution. |