SHOW SINKS
SHOW SINKS returns a list of all sinks available in Materialize.
Syntax
Details
| Field | Use |
|---|---|
| schema_name | The schema to show sinks from. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS. |
| cluster_name | The cluster to show sinks from. If omitted, sinks from all clusters are shown. For available clusters, see SHOW CLUSTERS. |
Output format
SHOW SINKS’s output is a table, with this structure:
name | type | size | cluster
------+------+------+--------
... | ... | ... | ...
| 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. Null if the sink is created using the IN CLUSTER clause. |
| cluster | The cluster the sink is associated with. |
Examples
SHOW SINKS;
name | type | size | cluster
--------------+-------+---------+--------
my_sink | kafka | | c1
my_other_sink | kafka | | c2
SHOW SINKS IN CLUSTER c1;
name | type | size | cluster
--------+-------+---------+--------
my_sink | kafka | | c1