Forum Discussion
Warehouse git integration auto generated metadata
I noticed that as of February 12, 2025, the git integration for a Warehouse introduced a new line, in the .sql files (which I can find on the git repository linked to a Fabric workspace) like the following:
warehouse_name.Warehouse/dbo/Views/MyView.sql
-- Auto Generated (Do not modify) 03638K95VLFDLM8XCCDG3A5IOR8EN05Q8DIEFEEI0PKR5L4MKGA20EE9LL4BM7ZA
I would like to be able to retrieve such a 64-character SHA from an API or be able to generate it locally from a string.
I know this is already marked as solved, but I would like to point out that MS Fabric stored procedures and views do not save comments before the CREATE key word in the data warehouse. So, while Microsoft generates this comment, it is not ultimately saved as part of the data warehouse view.
The result is that the data warehouse and the git file are always out-of-synch when comparing in VS Code schema compare. We are currently just ignoring that difference, but it would be very helpful if either comments would be recognized before the CREATE or if schema compare accounted for this extra auto-generated comment from MS Fabric.
