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.
ToddChitt
on:
Copy Job needs more functionality
on:
Support for Signed GitHub Commits
on:
Bug: Web URL Conditional Formatting Ignores "Show ...
on:
Apply Conditional Formatting to All Columns/Series...
yicw
on:
In Fabric view, let us assign workspace colors bas...
on:
Introducing Excel-Style Table in Power BI