Adf Dataflow Error Handling Sink Settings Element
X-Ref:
- Ast Adf Dataflow Error Handling Sink Settings Node
- Ast Adf Dataflow Sql Script Sink Settings Node
- Ast Adf Dataflow Database Sink Settings Base Node
- Ast Adf Dataflow Sink Settings Base Node
Attributes
Attribute | API Type | Default | Description |
---|---|---|---|
AllowDelete | String | Allow rows to be deleted in the sink. | |
AllowInsert | String | Allow rows to be inserted in the sink. | |
AllowUpdate | String | Allow rows to be updated in the sink. | |
AllowUpsert | String | Allow rows to be upserted in the sink. | |
BatchSize | String | "-1" | Size of batches for columnar caching. |
ErrorHandlingLinkedServiceName | AstAdfAzureStorageLinkedServiceBaseNode | Specifies a reference to the linked service that will store the log of errors. This references an existing definiton. | |
ErrorRowHandling | AdfErrorRowHandling | StopOnFirstError | Specifies whether to continue on error (StopOnFirstError vs AllErrors). |
OutputRejectedData | String | Specifies if rejected data should be logged in an error handling Linked Service. | |
RejectedContainer | String | Specifies the name of the rejected container in the error handling linked service's file structure. | |
RejectedFolder | String | Specifies the folderpath for the rejected file in the error handling linked service's file structure. | |
ReportSuccessOnError | String | Setting this to true marks the dataflow as a successful run, even if rows were rejected or errors were found. | |
TableAction | AdfDataflowSinkTableAction | None | Select the table action: None, Truncate, Recreate. |
TransactionCommit | AdfErrorHandlingTransactionCommit | Single | Commit each record or do it by batch. |
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. |
<KeyColumns> Multiple Choices... </KeyColumns> | AstAdfDataflowKeyColumnBaseNode | Choose which column(s) is used to determine if a row from the source matches a row from the sink. |
<PostSqlScripts> <Script /> </PostSqlScripts> | String | This is a collection of scripts to run after the sink action. |
<PreSqlScripts> <Script /> </PreSqlScripts> | String | This is a collection of scripts to run before the sink action. |