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

---

title: "SHOW CREATE CLUSTER" description: "SHOW CREATE CLUSTER returns the DDL statement used to create the cluster." menu: main:

parent: commands

---

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

Syntax

SHOW CREATE CLUSTER <cluster_name>

For available cluster names, see SHOW CLUSTERS.

Examples

SHOW CREATE CLUSTER c;

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

Privileges

{{< include-md file="shared-content/sql-command-privileges/show-create-cluster.md" >}}

Related pages

• SHOW CLUSTERS
• CREATE CLUSTER