Forum Discussion
Post ProdigyLooping to copy tables in a dynamic manner using T-SQL
In case of meta data driven farmework, you would need a config table to manage the list of lakehouse table you want to copy into warehouse.
Then you can query the lakehouse within the warehouse:
https://www.linkedin.com/pulse/querying-lakehouse-data-from-warehouse-microsoft-fabric-jovan-popovic
And using While loop, you can write a dynamic stored procedure to iterate over the table list and clone them within warehouse via EXECUTE keyword
example : Execute('Select * from table 1')
rather than select you can write the clone command
Super UserIn case of meta data driven farmework, you would need a config table to manage the list of lakehouse table you want to copy into warehouse.
Then you can query the lakehouse within the warehouse:
https://www.linkedin.com/pulse/querying-lakehouse-data-from-warehouse-microsoft-fabric-jovan-popovic
And using While loop, you can write a dynamic stored procedure to iterate over the table list and clone them within warehouse via EXECUTE keyword
example : Execute('Select * from table 1')
rather than select you can write the clone command
v-cboorla-msftMicrosoft Employee
Hi pmscorca
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.Thank you.
- v-cboorla-msft
Hi pmscorca
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. If you have any question relating to the current thread, please do let us know and we will try out best to help you. In case if you have any other question on a different issue, we request you to open a new thread.
Thank you.
- v-cboorla-msft
Hi pmscorca
Glad that your query got resolved.
Please continue using Fabric Community for further queries.Thank you.