.alter materialized-view lookback
Alters the lookback value of an existing materialized view. For more information on the lookback property, see materialized view create command properties.
.alter materialized-view MaterializedViewName lookback LookbackPeriod
Note
- A
lookbackfor a materialized view is only supported for EngineV3 clusters. - You must either be the database user who created the materialized view or have database admin permission to run this command.
Examples
.alter materialized-view MyView lookback 6h
To remove a lookback from the materialized view, use timespan(null) as the lookback argument:
.alter materialized-view MyView lookback timespan(null)