Forum Discussion
Fabric Data Warehouse git update issue with correct stored procedures
- 9 months ago
hi RehanH14 ,
Yes — this appears to be a known limitation in the current Git integration for Fabric Data Warehouse, which is still in preview.
What’s happening?
During Update from Git, Fabric attempts to re-deploy the stored procedure via SQL project logic.
This sometimes leads to false syntax errors, even if the procedure runs fine manually or in other workspaces.
Simply opening the procedure in Fabric and clicking Save often resolves it — confirming it's a deployment issue, not SQL syntax.
Known Issues (based on community + Microsoft docs):
Git + Warehouse sync can fail inconsistently, especially with stored procedures.
Microsoft documentation confirms that Git support is still evolving, with limitations around SQL object deployment.
Common issue threads: Example
Workarounds & Best Practices:
Use CREATE OR ALTER PROCEDURE instead of CREATE alone — it's more reliable during deployment.
Keep stored procedures modular and simple where possible.
Use deployment pipelines or SQL projects for production-grade rollouts.
Treat Update from Git as less predictable for complex SQL objects during preview.
If this post helps, then please appreciate giving a Kudos or accepting as a Solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot! - 9 months ago
Hi RehanH14 ,
This behavior is expected as Fabric Warehouse Git integration is currently in preview. Please wait for a fix in upcoming releases.
Best Regards,
Community Support Team.
Just an update that this appears to have not been fixed yet. I had the same issue today with Pipeline which has an activity to trigger a Fabrice Warehouse's Stored Procedure and a notebook activity to trigger a notebook with default Lakehouse in notebook's Lakehouse explorer.
Workspace A (feature) and workspace B (integration) are both connected to the same repo folder. I built a pipeline in A with a Stored procedure activity on warehouse wh_x (also in A), committed it, merged the PR, and ran Update in B. In B, the pipeline editor shows B's wh_x. But the stored definition (getDefinition) still has A's SQL endpoint in linkedService.typeProperties.endpoint, while artifactId and workspaceId are remapped. The run fails with 18456 "database was not found". The same thing happens to the notebook default lakehouse.
Is anyone aware of what is the alternative other than manually editing the activities after the pulling the changes into my integrated dev Workspace (Workspace B).
If the same issues affect other pipeline activities like lookup etc?