Hi @Aditya Singh
Thank you for your question and using Microsoft Q&A platform.
To replicate your pipeline multiple times in Azure Synapse Analytics with a different table name passed as a parameter for each instance, you can follow these steps:
- In your existing pipeline, create a parameter for the table name. Use this parameter in your activities. For example, I have a pipeline named 'ifelsepipeline' and I have created a parameter named 'tableName'.
I have used this parameter inside the lookup activity.
- Create a new pipeline that will act as a master pipeline. Add a ForEach activity to the master pipeline. This activity will iterate over a list of table names. Here I have created a new pipeline named 'ExecutePipeline'.
Add a variable of type 'Array' which contains the list of table names.
- Inside the ForEach activity, use an Execute Pipeline activity to call your original pipeline. Pass the table name parameter to the pipeline during each iteration of the ForEach loop.
- Execute the master pipeline. It will run the original pipeline 3 times in my case as I have given 3 table names, each time with a different table name. For more information related to Foreach activity please refer to this document:
https://learn.microsoft.com/en-us/azure/data-factory/control-flow-for-each-activity
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.