Azure Data Factory: parameterize reference to output activity

Paul Hernandez 631 Reputation points Microsoft Employee
2022-10-05T14:41:55.903+00:00

Hi everyone,

in ADF we are trying to evaluate whether is possible to parameterize the reference to an activity in a dynamic expression, like this:

Pipeline overview:
247773-image.png

Expression in Set variable "For error":
247814-image.png

I think this will always break validation but jus want to confirm it.

Any workaround?

BR.
Paul Hernandez

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

Accepted answer
  1. AnnuKumari-MSFT 31,721 Reputation points Microsoft Employee
    2022-10-06T07:52:05.5+00:00

    Hi @Paul Hernandez ,
    Thankyou for using Microsoft Q&A platform and thanks for posting your question here.
    As per my understanding you want to know if there is any way to parameterize the reference to an activity. Please let me know if my understanding is incorrect.

    It's not possible to call an activity dynamically by using pipeline parameters, however since you want to invoke set variable activity on failure of any of the prior activities, you can consider adding a dummy wait activity on success of both prior activities. If any of the activities fails, the dummy wait activity would be skipped and it would invoke the set variable 'For error' activity.

    Kindly refer to the below screenshot:
    248021-image.png

    For more details, kindly check out the following video: Run an activity if any one of set of activities fail in Azure data factory
    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful