ContextQMD
Back to Materialize

SHOW CREATE SINK

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

1231.3 KB
Original Source

SHOW CREATE SINK returns the DDL statement used to create the sink.

Syntax

sql
SHOW [REDACTED] CREATE SINK <sink_name>;

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

For available sink names, see SHOW SINKS.

Examples

mzsql
SHOW SINKS
nofmt
     name
--------------
 my_view_sink
mzsql
SHOW CREATE SINK my_view_sink;
nofmt
               name              |                                                                                                        create_sql
---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 materialize.public.my_view_sink | CREATE SINK "materialize"."public"."my_view_sink" IN CLUSTER "c" FROM "materialize"."public"."my_view" INTO KAFKA CONNECTION "materialize"."public"."kafka_conn" (TOPIC 'my_view_sink') FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_connection ENVELOPE DEBEZIUM

Privileges

The privileges required to execute this statement are:

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