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