Time Travel Error when selecting from materialized view (Azure Databricks)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2025 06:46 AM
Hey - running into an error this morning that was brought to my attention via failed refreshes from PowerBI. We have a materialized view that, when queried with the standard pattern of 'select col1 from {schema}.table_name', returns an error of 'Cannot time travel Delta Table to version XXXX'. This is odd to me for a few reasons.
1: materialized views don't support time travel as far as I can tell: https://learn.microsoft.com/en-us/azure/databricks/ldp/dbsql/materialized#limitations
2: The query isn't specifying any version.
I've tried changing computes between warehouse and serverless and I still get the same errors. There are other MV's in that pipeline with all the same dependencies, that are not having this issue.
Has anyone ran into this, or have any insight? Thanks