Home  /  Reference

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

DROP CLUSTER REPLICA IF EXISTS cluster_name.replica_name
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.
Back to top ↑