Forum Discussion
Solved
Two Capacities With Same Data
I have two Fabric capacities: one for internal reporting and one for external reporting. The goal of this setup is to avoid having internal users affecting external. As it turns out, the data for...
Then I would recommend loading the data into separate lakehouses.
Direct Lake.
Then I would recommend loading the data into separate lakehouses.
Follow up question on this: I tend to agree with you here. Is there any tool I can use to ensure the Internal and External stay in sync with each other? As stated previously, they will be the same data but only separated for usage concerns. If an update is made to one, the other would need to be updated as well.
You could decide to use the same data pipeline to feed both lakehouses. But yet again, a data pipeline is bound to a workspace so it will eat the CUs for that workspace's capacity.