Materialize Documentation
Join the Community github/materialize

SHOW SINKS

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

Syntax

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

Output format

SHOW SINKS’s output is a table, with this structure:

name  | type
------+-------
...   | ...
Field Meaning
name The name of the sink.
type Whether the sink was created by the user or the system.

Examples

SHOW SINKS;
name    | type
--------+-------
my_sink | user
my_sink