saurabh18cs
Honored Contributor III

Hi @EAnthemNHC1 there could be multiple reasons :

1) The materialized view is backed by a Delta table. If the underlying Delta table has been vacuumed (old versions removed), but the materialized view metadata or refresh logic tries to access a specific (now-missing) version, you’ll get a “Cannot time travel Delta Table to version XXXX” error.

2) If a refresh failed or was interrupted, the MV metadata may be out of sync with the underlying data.

trying forcing a refresh on MV

REFRESH MATERIALIZED VIEW {schema}.{table_name}

or worst trying re-creating a MV

Br