Materialize Documentation
s
Join the Community github/materialize

SHOW SINKS

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

Syntax

SHOW FULL 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.
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
Did this info help?
Yes No