Forum Discussion
How to call stored procedures Concurrently and sequentially through Data pipeline
Hello -
I have 10 stored procedures in Fabric Warehouse.
First 5 stored procedures to be run concurrently and remianing 5 to be run in sequentially by using Datapipeline. Please help us how to accomplish this in Microsoft Fabric?
Thanks in advance.
Thanks,
Lakshmi Narayana
You can have 2 variables :
1 variable with the parallel SP names semi colon seperated and another variable with the sequentail SP names semi colon seperated.
You can then use 2 for each activities (1 with sequentail flow and 1 with parallel flow) with input as split(variable,';') which would create an array for both the variables and within for each use SP activity
8 Replies
- NandanHegde
Super User
You can have 2 variables :
1 variable with the parallel SP names semi colon seperated and another variable with the sequentail SP names semi colon seperated.
You can then use 2 for each activities (1 with sequentail flow and 1 with parallel flow) with input as split(variable,';') which would create an array for both the variables and within for each use SP activity
NandanHegde : Thanks for the update. Since i am new to Fabric , could you please share the steps in pictorial approach with sample Variable and SP names and corresponding setting tabs.
Thanks,
Lakshmi Narayana
Hi jlakshminaraya
Are you asking the same query here : How to call multiple procedures in sequence or con... - Microsoft Fabric Community?
Hi jlakshminaraya
Thanks for using Fabric Community.
You can achieve the above requirement by using a layout as shown below:
Hope this helps. Please let me know if you have any further queries.Anonymous
Thanks for the update. Hope this work.
Hi jlakshminaraya
Please do let me know after you try this. Incase of any queries please feel free to reach out to us.
Glad to help.
