Forum Discussion

alozovoy's avatar
alozovoy
Icon for Advocate II rankAdvocate II
2 years ago
Solved

SQL Endpoint Slow To Reflect Changes In Lakehouse

I have been using notebooks to create and modify delta tables for several months. I run the notebooks in the browser app and then I query the table using the SQL endpoint to validate the changes. I u...
data engineering
  • alozovoy's avatar
    alozovoy
    2 years ago

    Microsoft support told me that it is a known issue and is in their internal issues tracker. However, it will not be added to the public Fabric Known Issues page. There is currently no timeline for a fix.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

This is a known issue with the metadata sync process which results in stale data when queries through the sql endpoint. 

The fix was scheduled for July 31 but has unfortunately been pushed back to September. 

The workaround is to create a separate workspace and Lakehouse, shortcut your existing Lakehouse tables into the new Lakehouse and the data will be fresh.