ALTER MATERIALIZED VIEW

ALTER MATERIALIZED VIEW changes the parameters of a materialized view.

Syntax

ALTER MATERIALIZED VIEW name SET ( RETAIN HISTORY = FOR retention_period )
ALTER MATERIALIZED VIEW name RESET ( RETAIN HISTORY )

Field Use
name The identifier of the materialized view you want to alter.
retention_period Private preview. This option has known performance or stability issues and is under active development. Duration for which Materialize retains historical data, which is useful to implement durable subscriptions. Accepts positive interval values (e.g. '1hr'). Default: 1s.

Details

Privileges

The privileges required to execute this statement are:

  • Ownership of the materialized view.
Back to top ↑