SHOW CREATE SINK
SHOW CREATE SINK returns the DDL statement used to create the sink.
Syntax
| 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;
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'