Copy Multiple tables from Azure SQL Via Vnet gatew…

Hi All,

 

Fabric newbie here. I do have experience in Azure data services (ADF, Databricks, SQL, ADLS etc)

 

I have a requirement where I have to copy multiple tables from a Azure SQL Database via a Vnet data gateway to fabric lakehouse.

 

1. Is there a way to copy it directly using Fabric notebooks? Is it possible to connect notebook to Azure SQL DB via Vnet data gateway?

 

2. If not, I was thinking about storing the list of tables in a control table and then looping it in Fabric data factory. but as of now Vnet data gateway is not supported in DF.

 

I know it might be possible using dataflow, but that is a complete new tech to me and I would need some guidance.

 

Please advise on how to proceed with with scenario. Thank you.

 

 

 

 

Read more here: Source link