Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Include views from Lakehouse SQL Analytics Endpoint in git source control and deployment pipelines

SQL Views added to a Lakehouse's SQL Analytics Endpoint should be synchronized to git source control as well as deployable through deployment pipelines. 

Specific use case: My team have a set of SQL views implemented in our Lakehouse's SQL Analytics Endpoint. These views are queried by semantic models to shape the data selected from the lakehouse's tables. When we turned on git integration for our Fabric workspaces, we were very surprised to find that the resulting repository did not include the view code, and that views were not copied between workspaces when we ran our deployment pipeline. Due to this limitation, we must control this code in a separate repo, as well as manually deploy updates to each Fabric workspace as we move through our dev lifecycle.

Thanks!

Status: New
Comments
loweg
Frequent Visitor
It would also be valuable if the queries, both personal and shared could be backed up to source control. No one wants to lose all that valuable information because someone accidentally delete a shared query.