Is there a way to abort the running flow in production based on data quality checks.

[4d0da1bbc392149914c7]

For example: If we are expecting only country values as "US" and "IND" in incoming source excel file and if anytime during production execution there is data for also "UK" in the source excel then the Flow has to get aborted.

This could work if it is possible to manually introduce recipe errors along with a message based on a condition so that at run time the flow is terminated if "ignore Recipe Errors" is unchecked

[APrasad_Tri]

Hi @Raghavendra CN? 

There are 2 ways:

1. Use of Data quality rules functionality provided in the recipe. and set the job options as below.
2. Create a flag and pass a string to an integer column. This will fail the flow due to data type mismatches.

Hope this helps.

Apeksha