DROP SINK
DROP SINK removes a sink from Materialize.
Dropping a Kafka sink doesn’t drop the corresponding topic. For more information, see the Kafka documentation.
Syntax
DROP SINK [IF EXISTS] <sink_name>;
| Syntax element | Description |
|---|---|
| IF EXISTS | Optional. If specified, do not return an error if the specified sink does not exist. |
<sink_name> |
The sink you want to drop. You can find available sink names through SHOW SINKS. |
Examples
SHOW SINKS;
my_sink
DROP SINK my_sink;
DROP SINK
Privileges
The privileges required to execute this statement are:
- Ownership of the dropped sink.
USAGEprivileges on the containing schema.