Forum Discussion
Dynamic SQL Connection (ForEach Loop)
Hi Everyone,
I'm trying to loop through multiple databases, each with a different connection string. All the databases have the same structure and format. My goal is to parameterize the connection and query so that I can extract information from each database dynamically.
So far, my findings suggest that this is not yet supported in Fabric. Any updates on this would be greatly appreciated.
Hello Tech122
Yes, you are correct. Parametrization for dynamic SQL connection in Fabric environment not supported currently. But we can expect them in upcoming release. Pls chek here for future release What's new and planned for Data Factory in Microsoft Fabric - Microsoft Fabric | Microsoft Learn
Pls go through the below accepeted solution. It will give you clarity.
Solved: Re: Dynamic Connection To Sources - Microsoft Fabric Community
Thank you!!!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
1 Reply
- suparnababu8Super User
Hello Tech122
Yes, you are correct. Parametrization for dynamic SQL connection in Fabric environment not supported currently. But we can expect them in upcoming release. Pls chek here for future release What's new and planned for Data Factory in Microsoft Fabric - Microsoft Fabric | Microsoft Learn
Pls go through the below accepeted solution. It will give you clarity.
Solved: Re: Dynamic Connection To Sources - Microsoft Fabric Community
Thank you!!!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!