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

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

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.
TheFlyingBadger
Frequent Visitor
Agreed. If we are to use Fabric as an enterprise data store then there needs to be source control
hedeencharles
Advocate I
Any update on this feature? It would be great to track sql endpoint views in git source control. Thanks
zg31210
Regular Visitor
Agreed! Please add SQL Views as part of Git Integration for better Lakehouse CI/CD support.