DROP 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;

Create a sink