ContextQMD
Back to Materialize

SHOW CREATE CLUSTER

doc/user/content/sql/show-create-cluster.md

123897 B
Original Source

SHOW CREATE CLUSTER returns the DDL statement used to create the cluster.

Syntax

sql
SHOW CREATE CLUSTER <cluster_name>

For available cluster names, see SHOW CLUSTERS.

Examples

sql
SHOW CREATE CLUSTER c;
nofmt
    name          |    create_sql
------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 c                | CREATE CLUSTER "c" (INTROSPECTION DEBUGGING = false, INTROSPECTION INTERVAL = INTERVAL '00:00:01', MANAGED = true, REPLICATION FACTOR = 1, SIZE = '100cc', SCHEDULE = MANUAL)

Privileges

{{% include-headless "/headless/sql-command-privileges/show-create-cluster" %}}