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