SHOW CREATE SINK

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

Syntax

SHOW CREATE SINK sink_name
Field Use
sink_name The sink you want use. You can find available sink names through 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" 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 WITH (SIZE = '3xsmall')

Privileges

The privileges required to execute this statement are:

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