Data Warehouse Metadata Sync Issue

[Parthiban006]

We are experiencing multiple issues in Fabric Data Warehouse related to UI consistency and metadata visibility:

1. Views Not Visible in UI

• When we create views in the warehouse, they are not visible in the Fabric UI under Schemas → Views.
• However, the same views are accessible and queryable, confirming that they are created successfully.

2. Delay in Reflecting Table Changes

• When we add or drop columns in a table, the changes are not immediately reflected in the UI.
• In some cases, it takes 1–2 days for the updates to appear.

3. Metadata/UI Synchronization Issue

• There appears to be a significant delay or inconsistency between backend metadata and UI rendering.
• This is causing confusion during development, validation, and downstream activities.

---

Questions:

• Is this a known limitation or a bug in Fabric Data Warehouse?
• Are there any recommended workarounds or methods to force a metadata/UI refresh?

[v-saisrao-msft]

Hi @rizalard0684,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

Hi @Parthiban006,

Have you had a chance to review the solution we shared by @Lodha_Jaydeep, @tayloramy, @rizalard0684? If the issue persists, feel free to reply so we can help further.

Thank you.

[rizalard0684]

Hi @Parthiban006 to make sense what is going on, from an architecture perspective:

Fabric has a central metadata platform with multiple workloads sharing that metadata. Hence there is no guarantee that UI reflects changes in real time.

I typically escalate to Microsoft when:

• Views never appear after multiple days
• UI shows incorrect schema vs query output
• Downstream tools are impacted (not just UI)

Otherwise, we treat this UI sync behaviour as expected "eventual consistency". What we consider the source of truth is the SQL, not the portal.

[tayloramy]

Hi @Parthiban006, 

Are you experiencing this in Warehouses, or in Lakehouses? 
Lakehouses do have a metadata sync that needs to occur before the SQL Endpoint is updated, which is what the answer @Lodha_Jaydeep linked is talking about. 

[Lodha_Jaydeep · Accepted solution]

Hi @Parthiban006,

Kindly review the blog post, as similar issues seem to have been addressed previously. It may provide useful guidance. Please feel free to reach out if you have any issues.
https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Warehouse-UI-not-syncing-anymore/m-p...