Materialized Views: Using Time Travel to Query Historical Data Produces Expected Error Message


This behavior change is in the 2023_01 bundle.

For the current status of the bundle, refer to Bundle History.

When Time Travel is incorrectly used to query historical data for materialized views, an error message now states that Time Travel is not supported:


Although Time Travel is not supported for materialized views, queries with the AT or BEFORE keyword in the FROM clause might have returned unexpected results. In some cases, queries might also have returned an unexpected error message. For example, for the Time Travel clause: CAST('2022-11-29 00:00:00' AS TIMESTAMP_LTZ(9)).


Querying historical data using Time Travel on materialized views produces a SQL compilation error:

Time travel is not supported for materialized views.

Ref: 923