cookiebaker
New Contributor III

Since last monday december 8th we're experiencing this same issue: Cannot time travel Delta table to version 158. Available versions: [70, 4]. However, this is just when doing a simple SELECT * statement from a gold view (without any version specified). The issue seems to start in the silver layer of that live table (materialized view). Since DLT stores that as a materialized view we cannot see the version history of the table. The bronze tables of which the silver layer is build up of, can all be queried successfully. 

Another interesting thing to mention: The error only occurs when querying from  ADB environment A with SQL Warehouse A on the table in Unity Catalog 'production', however, when we're querying from ADB environment B, with its own SQL warehouse B, but the same table in Unity Catalog 'production', then I can query the tables successfully, without any of the version errors. The versions of the serverless sql warehouses and their channels are exactly the same in both environments.