ContextQMD
Back to Materialize

SHOW CREATE SOURCE

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

123967 B
Original Source

SHOW CREATE SOURCE returns the DDL statement used to create the source.

Syntax

sql
SHOW [REDACTED] CREATE SOURCE <source_name>;

{{< yaml-table data="show_create_redacted_option" >}}

For available source names, see SHOW SOURCES.

Examples

mzsql
SHOW CREATE SOURCE market_orders_raw;
nofmt
                 name                 |                                      create_sql
--------------------------------------+--------------------------------------------------------------------------------------------------------------
 materialize.public.market_orders_raw | CREATE SOURCE "materialize"."public"."market_orders_raw" IN CLUSTER "c" FROM LOAD GENERATOR COUNTER

Privileges

The privileges required to execute this statement are:

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