SHOW SINKS

NOTE! For improved performance, execute this command in the mz_introspection cluster. To switch clusters, use SET CLUSTER = mz_introspection;.

SHOW SINKS returns a list of all sinks available to your Materialize instances.

Syntax

SHOW SINKS FROM schema_name

Details

Field Use
schema_name The schema to show sinks from. Defaults to public in the current database. For available schemas, see SHOW SCHEMAS.

Output format

SHOW SINKS’s output is a table, with this structure:

name  | type
------+-------
...   | ...
Field Meaning
name The name of the sink.
type The type of the sink: currently only kafka is supported.
size The size of the sink.

Examples

SHOW SINKS;
name    | type  | size
--------+-------+--------
my_sink | kafka | small
xl_sink | kafka | xlarge
Back to top ↑