Alternative to avoid multiple set varaible activities

Anusha 26 Reputation points

Is there any way I can set multiple variables without having dozens of Set Variable activities in my pipeline? (my main pipeline that I want to keep clean).

Any help is appreciated, thank you

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

Accepted answer
  1. AnnuKumari-MSFT 31,561 Reputation points Microsoft Employee

    Hi @Anusha ,
    Welcome to Microsoft Q&A platform and thanks for posting your question here.
    As per my understanding to your query, you are trying to assign value to a variable holding filepath so that it can be reused in the pipeline multiple times . You want to avoid the task of creating multiple set variables activities to do that. Please let me know if my understanding is incorrect.

    In this case, you can make use of pipeline parameter to which you can assign value that would be accessible to any activities within that pipeline. You can also create Global parameter in ADF that would be accessible throughout the ADF workspace that means multiple pipelines.

    Note: Limit on the number of pipeline parameters in ARM template is 256 parameters. Source: Template limits

    To know more details about parameters in ADF, kindly visit the following videos:
    Pipeline paramters in ADF
    Global parameters in ADF

    Hope this will help. Please let us know if any further queries.


    • Please don't forget to click on 130616-image.png button and take the satisfaction survey 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