SHOW CREATE SINK
SHOW CREATE SINK returns the DDL statement used to create the sink.
Syntax
SHOW [REDACTED] CREATE SINK <sink_name>
| Option | Description |
|---|---|
| REDACTED | If specified, literals will be redacted. |
For available sink names, see SHOW SINKS.
Examples
SHOW SINKS
name
--------------
my_view_sink
SHOW CREATE SINK my_view_sink;
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:
USAGEprivileges on the schema containing the sink.