Forum Discussion

kozman's avatar
kozman
New Member
8 days ago

Views in Warehouse Breaks Source Control Sync

When I create a view in a warehouse and have it point to a table in a corresponding lakehouse in the same workspace, I am unable to sync a new workspace from a git branch.  Reason is that the lakehou...
data warehouse
warehouse
AvdBerg's avatar
AvdBerg
Frequent Visitor
7 days ago

Hi kozman​ 

As git intergrations for Fabric Warehouses are still in Preview i think you could be encountering one of its limitations.

Cross-item dependencies between warehouses and SQL analytics endpoints aren't currently supported in development workflows. As a result, scenarios that rely on coordinated changes across these items might not work reliably.

Source: https://learn.microsoft.com/en-us/fabric/data-warehouse/git-integration

A workaround might be to follow these steps, until the limitation is no longer there.

  1. Branch out to the new workspace with Select items individually checked, including only the Lakehouse (not the Warehouse)
  2. Populates that Lakehouse in this environment, get its tables to exist.

  3. Go back to source control and run a scoped update from git (Documentation), this should resolve the lakehouse dependency. (Should because it is still a preview item)

Hopefully this helps you.

Did I answer your question, please mark the post as a solution.