Dynamically retrieving name of storage account in Azure Data Factory

Question

I have multiple pipelines in different environments (dev, test, stage etc...). Is there a way that I can dynamically retrieve the name of the storage account (the name tells you the environment it's running in) in azure data factory so that I can make changes based on the env?

Answer 1

Hi @Michael Vu ,
Thanks for posting your question in Microsoft Q&A platform.
By the above query , do you mean fetching the storage account name dynamically from Linked service or a dataset? If Yes , then it's not possible as there is a one to many mapping between Storage account and linked service. Moreover, I hope for different environments, you are using different ADF.
In this scenario, you can create a lookup table and store the storage account names for different environment in the table and use this expression to fetch the details of storage account based on the environment.

select * from LookUpTable where ADFEnvironment='@{pipeline().DataFactory}'  

Please check the below screenshots for reference.

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

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

• Please don't forget to click on or upvote 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