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.
on:
Improve error message when dataset mixes cloud and...
on:
Deployment pipeline rule for data factory pipeline...
on:
Epic Idea: Show visual dependencies for bookmarks
on:
Customize messaging for Report Access Requests
dm-p
on:
Allow standard Focus Mode for custom visuals that ...
Hi @rob_carrol1, I want to provide an update. Recently we've announced the ability query Lakehouse files (Data Virtualization in SQL Database - Microsoft Fabric | Microsoft Learn) and we are actively working on adding support for Lakehouse table, as soon as we lock-in an ETA you'll be able on aka.ms/fabricroadmap website.