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 for performing time travel queries. Accepts positive interval values (e.g. '1hr'). Default: 1s. |
Details
Privileges
The privileges required to execute this statement are:
- Ownership of the materialized view.