Connecting Fabric lakehouse or Warehouse to SQL server using Polybase

[Raavanan_7]

Hi Fabric Enthusiast!

I recently encountered a requirement to migrate existing data from SQL Server to Fabric Lakehouse or Warehouse, making Fabric the permanent source for operations previously built and running. As part of the process, I also need to delete the records from SQL Server after the migration to reduce the storage cost.

Additionally, I need to query the data stored in Fabric Lakehouse or Warehouse from SQL Server using PolyBase to run previously build application using sql sp as a source.

The data which is going to be migrated are history tables which is not mostly used.

Is it possible to connect Fabric Lakehouse to SQL Server using PolyBase? If so, could you please provide some guidance?

Thanks!

[v-huijiey-msft · Accepted solution]

Hi @Raavanan_7 ,

While Polybase, a feature in SQL Server, allows working with external data sources, it doesn't currently offer direct integration with Fabric Lakehouse Delta tables.

Appreciate if you could share the feedback on our Home. 

You can use Dataflow Gen2 in the fabric to bring SQL Server data directly into lakehouse.

More detailed information on using SQL Server data in lakehouse and the steps to do so can be found in the documentation below:

How to bring SQL Server data into Microsoft Fabric - Data Mozart

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!