ALTER MATERIALIZED VIEW
ALTER MATERIALIZED VIEW changes the parameters of a materialized view.
Syntax
| 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.