.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 lookback for 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)