ContextQMD
Back to Materialize

SHOW SOURCES

doc/user/content/sql/show-sources.md

1231.5 KB
Original Source

SHOW SOURCES returns a list of all sources available in Materialize.

Syntax

mzsql
SHOW SOURCES [ FROM <schema_name> ] [ IN CLUSTER <cluster_name> ];
Syntax elementDescription
FROM <schema_name>If specified, only show sources from the specified schema. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS.
IN CLUSTER <cluster_name>If specified, only show sources from the specified cluster. For available clusters, see SHOW CLUSTERS.

Details

Output format for SHOW SOURCES

SHOW SOURCES's output is a table, with this structure:

nofmt
name  | type | cluster
------+------+--------
...   | ...  | ...
FieldMeaning
nameThe name of the source.
typeThe type of the source: kafka, postgres, load-generator, progress, or subsource.
clusterThe cluster the source is associated with.

Examples

mzsql
SHOW SOURCES;
nofmt
            name    | type     | cluster
--------------------+----------+---------
 my_kafka_source    | kafka    | c1
 my_postgres_source | postgres | c2
mzsql
SHOW SOURCES IN CLUSTER c2;
nofmt
name               | type     | cluster
-------------------+----------+--------
my_postgres_source | postgres | c2