Ask from creating linked service level & dataset level para... - Microsoft Fabric Community
I need to create linked service level and Dataset level parameters in Microsoft Fabric.
Scenario:1) I have multiple Databases in one Azure SQL server and I need to move some tables from DatabaseA to Lakehouse by using pipeline1
2)I need to move some tables from DatabaseB to Lakehouse by using same pipeline(pipelin1) and need to give database name on the fly(with parameters)
Table name can be parameterized, but database name is in connection, which does not support parameterization yet.
2 Comments
I our case, we have the same database coming from 2 subsidiary.
I were cool if we can manage the connection dynamically, then we can have 1 pipeline for both sources and we just need to change a pipeline parameter.
- Status added:Under Review
