Read Data from Lakehouse inside a Fabric SQL Database (using T-SQL)

[rob_carrol1]

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 example:

SELECT *

FROM SilverLakehouseDeltaTable x

JOIN GoldDatabaseSQLTable y ON y.id = x.id

This should be part of a INSERT / UPDATE or MERGE such as:

INSERT INTO AnotherGoldDatabaseSQLTable

(Columns)

SELECT *

FROM SilverLakehouseDeltaTable x

JOIN GoldDatabaseSQLTable y ON y.id = x.id

The ability to read data from OneLake in a Fabric SQL database would solve this problem.

[nishalit]

We are actively working on this ask.