SHOW SINKS
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. |
| FULL | Return details about your sinks. |
Output format
SHOW FULL SINKS’s output is a table, with this structure:
cluster | name | type | volatile
--------+-------+------+---------
... | ... | ... | ...
| Field | Meaning |
|---|---|
| cluster | The name of the cluster containing the sink. |
| name | The name of the sink. |
| type | Whether the sink was created by the user or the system. |
| volatility | Whether the sink is volatile. Either volatile, nonvolatile, or unknown. |
Changed in v0.5.0:
The output column is renamed from SINKS to name.
New in v0.7.2:
The volatile column.
New in v0.23.0:
The cluster column.
Examples
SHOW SINKS;
my_sink