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