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

[rob_carrol1]

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 SQL database:

INSERT INTO AnotherGoldDatabaseSQLTable

(Columns)

SELECT *

FROM SilverLakehouseDeltaTable x

JOIN GoldDatabaseSQLTable y ON y.id = x.id

This isn't currently possible with Fabric SQL Database.

[nishalit]

We are actively working on this ask.