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 comments