Blog Post

Azure Data Factory Blog
2 MIN READ

How to Handle SQL DB Row-level Errors in ADF Data Flows

Mark Kromer's avatar
Mark Kromer
Icon for Microsoft rankMicrosoft
Nov 21, 2020
When writing data to Azure SQL DB as part of your Data Factory ETL job using data flows, there are a number of features available to you that can handle common constraints found in target tables incl...
Published Nov 21, 2020
Version 1.0
azure data factory
Azure ETL
Mapping Data Flows
mirsky72's avatar
mirsky72
Copper Contributor
Jun 28, 2021

Any plans to enhance this functionality such as:

 

1.  "Attempt to write error rows to an Error Event Sink Table (RDBMS, Spark, and Hive only)"

2.  "Attempt to write error rows to a table (in bulk) of all varchar columns with same table name and different schema name"

      a. Threshold percentage of error rows to non-error rows to trigger an error status

 

This functionality is a bedrock of many data warehouses.