Warehouse git update: Specify sequence of views

[frithjof_v]

Hi,

I'm getting an error when trying to branch out (create a feature branch from) a workspace that contains a Warehouse.

The Warehouse has multiple views, some of which refer to other views in the T-SQL code.

The Git update into the new workspace fails because the update is trying to create a view before it has created the view which the view depends on.

Please make it possible to specify the sequence of views to update/deploy, so we don't get these issues.

Thanks!

[pradeepsvs]

Are you referring cross warehouse scenario?

[frithjof_v]

Perhaps the issue is due to cross warehouse. In my project, the warehouse views are referencing tables from a Lakehouse SQL Analytics Endpoint. So this might be a cross warehouse issue, yes.

[frithjof_v]

It is possible that the real error is that the Git update tries to create the Warehouse views before the Git update creates the tables in the Lakehouse SQL Analytics Endpoint. If that is indeed my problem, then the workspace Git update should allow me to specify that the Lakehouse should be updated first, and then I should be able to specify that the Warehouse should be updated afterwards. Ref. https://community.fabric.microsoft.com/t5/Fabric-Ideas/Allow-to-select-ITEMS-to-git-update-or-modify...