Materialize Logo

SHOW CREATE SINK

SHOW CREATE SINK returns the CREATE SINK 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
     SINKS
--------------
 my_view_sink
SHOW CREATE SINK my_view_sink;
               Sink              |                                                                                                        Create Sink
---------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 materialize.public.my_view_sink | CREATE SINK "materialize"."public"."my_view_sink" FROM "materialize"."public"."my_view" INTO KAFKA BROKER 'localhost:9092' TOPIC 'my_view_sink' FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY 'http://localhost:8081'