ADF - Is there a way to run an activity based from EACH prior activity

Resurreccion, Kevin Carl V 20 Reputation points
2023-01-17T09:25:36.37+00:00

I have this activity flow that each execute pipeline success run need the next activity to run for each and not to wait for each other to execute the next activity

User's image

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
0 comments No comments
{count} votes

Accepted answer
  1. Pratik Somaiya 4,206 Reputation points
    2023-01-17T10:03:42.0966667+00:00

    Hello

    We cannot get an output from inside of an execute activity, so you cannot get the activity status value to decide whether to execute foreach

    Instead, I would recommend, using a stored procedure as the last activity in the pipeline for both Execute pipeline activities which will store the status value as success against the pipeline run id in a log kind of table if the pipeline executed till the last activity

    Then in the lookup you can lookup on that log table as well to get the success status against a pipeline run id which you can get from execute pipeline

    In this case you will not have to link both activities to the lookup, any one can be linked but lookup will run for both execute activities based on log table result

    This seems to be clumsy but I don't think there's a direct way out in a general ADF pipeline

    Thank you

    0 comments No comments

0 additional answers

Sort by: Most helpful