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
Field Use
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.
  • USAGE privileges on the containing schema.
Back to top ↑