Home  /  Reference

ALTER SET CLUSTER

ALTER SET CLUSTER changes the association of an object to a cluster.

PREVIEW This feature is in private preview. It has known performance or stability issues and is under active development. It isn't subject to our backwards compatibility guarantees.

You must contact us to enable this feature in your Materialize region.

Syntax

ALTER MATERIALIZED VIEW IF EXISTS name SET IN CLUSTER cluster_name

Examples

Materialized view

Move a materialized view to a specific cluster:

ALTER MATERIALIZED VIEW mv1 SET CLUSTER c1;

Privileges

The privileges required to execute this statement are:

  • Ownership of the object.
  • CREATE privilege in the cluster.

See also

Back to top ↑