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.
2 Comments
- We are actively working on this ask.
- Status added:Planned
