Read Data from Lakehouse inside a Fabric SQL Database (using T-SQL)
We are working on a migration project to Fabric and need to combine data from inside a SQL Database with data in a Lakehouse then write it to another table in the database. Due to T-SQL compatibility issue with Data Warehouse, we want to use a Fabric SQL database for the Gold layer. For exampl...
STATUS
DETAILS
Planned
Read Data from Lakehouse inside a Fabric SQL Database (using T-SQL)
It should be possible to query data in a Fabric Lakehouse directly in Fabric SQL database using T-SQL. For example I have the following scenario where I want to join data from a table in my Fabric SQL DB to a delta table in my lakehouse then insert the resultset into another table in my Azure ...
STATUS
DETAILS
Planned