Forum Discussion
Lakehouse - sync issues to SQL en`dpoint
I have a delta table in lakehouse which is populated by a notebook from another delta table When I query the table ditrect I see records that I dont see when I query the table fromn the SQL endpoint...
Here is some documentation regarding SQL Analytics Endpoint performance:
https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-analytics-endpoint-performance
Also, if you by chance have used column name mapping to alter your table, it will stop syncing to the SQL Analytics Endpoint.
Thank you for providing the MS learn link.
"Under normal operating conditions, the lag between a lakehouse and SQL analytics endpoint is less than one minute."
The lag between lakehosue and SQL endpoint was showing the difference for me and MS Learn does confirm the lag as it takes around 1 minute to update the SQL endpoint. In my secnario, I needed to access the data right after updating the lakehouse table, hence I was getting the difference.