Home  /  SQL commands

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>;
Syntax element Description
IF EXISTS Optional. If specified, 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 ↑