Known issue - Using an inactive SQL analytics endpoint can show old data
If you use a SQL analytics endpoint that hasn't been active for a while, the SQL analytics endpoint scans the underlying delta tables. It's possible for you to query one of the tables before the refresh is completed with the latest data. If so, you might see old data being returned or even errors being raised if the parquet files were vacuumed.
Status: Open
Product Experience: Data Warehouse
Symptoms
When querying a table through the SQL analytics endpoint, you see old data or get an error, similar to: "Failed to complete the command because the underlying location does not exist. Underlying data description: %1."
Solutions and workarounds
You can retry after allowing the SQL analytics endpoint to complete its refresh process.
Next steps
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for