DROP CLUSTER
DROP CLUSTER removes an existing cluster from Materialize. If there are indexes or materialized views depending on the cluster, you must explicitly drop them first, or use the CASCADE option.
Syntax
| Field | Use |
|---|---|
| IF EXISTS | Do not return an error if the specified cluster does not exist. |
| cluster_name | The cluster you want to drop. For available clusters, see SHOW CLUSTERS. |
| CASCADE | Remove the cluster and its dependent objects. |
| RESTRICT | Do not drop the cluster if it has dependencies. (Default) |
Examples
Dropping a cluster with no dependencies
To drop an existing cluster, run:
DROP CLUSTER auction_house;
To avoid issuing an error if the specified cluster does not exist, use the IF EXISTS option:
DROP CLUSTER IF EXISTS auction_house;
Dropping a cluster with dependencies
If the cluster has dependencies, Materialize will throw an error similar to:
DROP CLUSTER auction_house;
ERROR: cannot drop cluster with active indexes or materialized views
, and you’ll have to explicitly ask to also remove any dependent objects using the CASCADE option:
DROP CLUSTER auction_house CASCADE;
Privileges
The privileges required to execute this statement are:
- Ownership of the dropped cluster.