Search code examples
azureazure-data-factorypipelineazure-synapse

ADF Pipeline to Succeed even if activity fails

I have a pipeline which i'm working on, i'm doing a lookup to check if few files are there, if the folder path is not there i have to perform certain processes, when the folder path is not present, the lookup activity fails and the red-line flow triggers and does few post-processes.

When those post-processes succeed, the overall pipeline fails, the error message says the lookup failed so overall pipeline also failed, I want my overall pipeline to also show succeed.

https://learn.microsoft.com/en-us/azure/data-factory/tutorial-pipeline-failure-error-handling This documentation says it'll succeed but it still fails.

enter image description here

Solution

  • In order to make your pipeline successful, you need to implement DO-IF-SKIP-ELSE. That is you can add a dummy Wait activity on skipping of true block activity.

    Check the pipeline image: enter image description here

    • Adding dummy activity when true activities are skipped will make your pipeline success.