Configuration of Lakehouse or fabric SQL Database as a Linked Sever

[Raavanan_7]

I have migrated the archeived data from On prem SQL data base to fabric lake house. we are currently planning to delete the archeived data in on prem. After that i want to run a already existing jobs sql jobs which depends the archeived data. i want to read the data in lakehouse in SSMS. Is it possible to connect lakehouse a linked server in ssms?

[v-pnaroju-msft]

Hi Raavanan_7,

We would like to inquire if the solution offered by @nilendraFabrichas resolved your issue. If you have discovered an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

Should you find the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to related queries.

Thank you.

[nilendraFabric]

Hello @Raavanan_7 

Yes, it is possible to connect to a Microsoft Fabric Lakehouse SQL endpoint from SQL Server Management Studio (SSMS), but it cannot be configured as a linked server

https://learn.microsoft.com/en/fabric/data-warehouse/connectivity

if this is helpful please accept the solution 

thanks