Integrating with Git end to end

[Nikhil234]

Hi All, 

I have set up my Git intigration with github and it all seems to work fine in the fabric UI. 

I now want to take this to the next step and start working locally. Ideally i would like to accsess my warehouse locally through vs code or some IDE and make my edits to exsiting views/stored proedures there and push this through Git. 

Can someone point me me to some good documentation to look at this end to end and look to set this up or even a video if thats possible.  

Thanks 

[v-kpoloju-msft · Accepted solution]

Hi @Nikhil234,
Thank you for reaching out to the Microsoft fabric community forum. Thank you @ for your inputs on this issue.

After reviewing the details you provided, I have identified few workarounds that may help resolve the issue. Please follow these steps:

First, ensure your Fabric workspace is connected to your GitHub repository: Navigate to your Fabric workspace settings, select Git integration, and choose GitHub as your provider. Specify the repository, branch, and folder you wish to connect, then initiate the sync between the workspace and the Git repository. This connection enables version control for your Fabric items, such as views and stored procedures.

To work locally on your warehouse objects, install the necessary extensions: Install the mssql extension in VS Code to connect to SQL databases. Optionally, install the Fabric Data Engineering extension to interact with Fabric-specific features.

Clone your GitHub repository: Use Git to clone the repository connected to your Fabric workspace and open the cloned repository in VS Code. Edit warehouse objects by navigating to the relevant .sql files representing your views or stored procedures and making your desired changes directly in these files.

Commit and push changes: Use Git commands within VS Code to commit your changes and push the commits to the connected GitHub branch. Upon pushing, your changes will be reflected in the Fabric workspace after syncing.

For collaborative development and isolated testing, create feature branches in your GitHub repository. In Fabric, use the Branch out feature to create a new workspace linked to your feature branch. Develop and test changes in this isolated environment. Once validated, merge the feature branch back into the main branch and sync the primary workspace.

Kindly refer to the below documentation links for better understanding:
Get started with Git integration - Microsoft Fabric | Microsoft Learn
Git integration process - Microsoft Fabric | Microsoft Learn
Source Control with Warehouse (Preview) - Microsoft Fabric | Microsoft Learn
Git integration and deployment for data pipelines - Microsoft Fabric | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.