DROP SINK

Use the DROP SINK command to remove a sink if you no longer need to deliver data to the sink.

Syntax

DROP SINK [ IF EXISTS ] [schema_name.]sink_name [ CASCADE ];

Parameter	Description
schema_name	The schema of the sink that you want to remove. You can use `SHOW SCHEMAS` to get a list of all available schemas. If you don't specify a schema, the specified sink in the default schema `public` will be removed.
sink_name	The name of the sink to remove.
CASCADE option	If this option is specified, all objects (such as materialized views) that depend on the sink, and in turn all objects that depend on those objects will be dropped.

This statement removes the sink rw_sink in the default schema public from the database:

DROP SINK rw_sink;

This statement removes the sink rw_sink in the schema rw_schema from the database:

DROP SINK IF EXISTS rw_schema.rw_sink;