An Azure service for ingesting, preparing, and transforming data at scale.
How to check multiple assert failure without failing the data flow?
Rohit Kharade
20
Reputation points
Is there a way to check multiple assert conditions at once without failing data flow in ADF pipeline? We have three different assert checks, and enabling the "Fail data flow" option during each assert will not proceed further in case there is any failure. Each assert check may require different data, so we have not added similar conditions in a single assert.
These are the three different assert checks:
- Checking null values in excel column.
- Checking duplicate values of 3 column combination.
- Validating 1 column with data in SQL server.
Azure Data Factory
Azure Data Factory
Sign in to answer