Materialize Logo

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:

 name  | type | volatile
-------+------+---------
 ...   | ...  | ...
Field Meaning
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.

Examples

SHOW SINKS;
my_sink
Did this info help?
Yes No