Looping · Learn Microsoft Fabric

Looping

Hi, we had a contractor in to help us on our fabric journey, they had some technical issues retrieving data from our on prem db2 and oracle databases, with fabric gen 2, so they built a solution in ADF, I like the way they did this and would like to know if there are any tutorials that do the same.

We have a control table that contains a list of all the tables we need to be copied from our source to our bronze LH, the ADF loops through each line in the control table and retrieves that table, if I want to get a different table, I simply add a new row to the control table with the name of the source table, then this is automatically copied, I don’t need to worry about creating a destination table or worry about column data types, its all done for me using this method. I’d like to redo this in fabric and not rely on ADF.

Thoughts ?

2 comments