Share via

How to check multiple assert failure without failing the data flow?

Rohit Kharade 20 Reputation points
2023-11-09T05:08:43.9033333+00:00

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:

  1. Checking null values in excel column.
  2. Checking duplicate values of 3 column combination.
  3. Validating 1 column with data in SQL server.
Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.