DROP CLUSTER REPLICA
DROP CLUSTER REPLICA
deprovisions an existing replica of the specified
unmanaged cluster. To remove
the cluster itself, use the DROP CLUSTER
command.
💡 Tip: When getting started with Materialize, we recommend starting with managed
clusters.
Syntax
Field | Use |
---|---|
IF EXISTS | Do not return an error if the specified cluster replica does not exist. |
cluster_name | The cluster you want to remove a replica from. For available clusters, see SHOW CLUSTERS . |
replica_name | The cluster replica you want to drop. For available cluster replicas, see SHOW CLUSTER REPLICAS . |
Examples
SHOW CLUSTER REPLICAS WHERE cluster = 'auction_house';
cluster | replica
---------------+---------
auction_house | bigger
DROP CLUSTER REPLICA auction_house.bigger;
Privileges
The privileges required to execute this statement are:
- Ownership of the dropped cluster replica.
USAGE
privileges on the containing cluster.