May '24 (edited) • Technical
How to read data from lakehouse and write(upsert) to warehouse?
(Why? To plan Gold layer DWH ingestion)
- COPY statement - TSQL: But it can read data only from ADLS or Azure Blob.
- Data Pipeline: It can read from lakehouse, but destination/sink supports only append.
- Data flow: It can read from lakehouse, but write mode available are append and replace.
- Cross warehouse ingestion: Seems not supported for lakehouse.
2
16 comments
How to read data from lakehouse and write(upsert) to warehouse?
skool.com/microsoft-fabric
Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.
Leaderboard (30-day)
1
+33
2
+24
3
+19
4
+15
5
+13
Powered by