Activity
Mon
Wed
Fri
Sun
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
What is this?
Less
More

Memberships

Learn Microsoft Fabric

15.4k members • Free

1 contribution to Learn Microsoft Fabric
Best Practice for bringing data from Lakehouse to Warehouse
Hi! Have a client that is implementing Fabric in the lowest capacity possible due to budget constraints. To try to maintain costs under control we are trying to find the best practices or best way to bring data from Lakehouse into the Warehouse that will minimize CU usage, can be scheduled, needs to have incremental refresh and uses SQL to get data.We've tried a bit with a Copy Activity and SQL queries inside this activity, which achieves most of the requirements but it seems that CU usage is still high. Any recommendations? We are thinking about trying stored procedures and schedule it through a pipeline...any other ideas?We have not considered mirroring because most of the tables have no column fro date / time from source systems.
0
0
1-1 of 1
Juliana Macedo
1
5points to level up
@juliana-macedo-1899
Data Enginneer / Data Analyst

Active 19h ago
Joined May 8, 2024
Powered by