alter-materialized-view.md 1.2 KB
title: "ALTER MATERIALIZED VIEW"
description: "ALTER MATERIALIZED VIEW changes the parameters of a materialized view."
menu:
main:
parent: 'commands'
ALTER MATERIALIZED VIEW changes the parameters of a materialized view.
Syntax
{{< diagram "alter-materialized-view-set.svg" >}} {{< diagram "alter-materialized-view-reset.svg" >}}
| Field | Use |
|---|---|
| name | The identifier of the materialized view you want to alter. |
| _retentionperiod | *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:
{{< include-md file="shared-content/sql-command-privileges/alter-materialized-view.md" >}}