SHOW CREATE SOURCE

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

Syntax

SHOW CREATE SOURCE source_name
Field Use
source_name The source you want use. You can find available source names through SHOW SOURCES.

Examples

SHOW CREATE SOURCE market_orders_raw;
                 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:

  • USAGE privileges on the schema containing the source.
Back to top ↑