SHOW SOURCES
SHOW SOURCES
returns a list of all sources available in Materialize.
Syntax
Field | Use |
---|---|
schema_name | The schema to show sources from. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS . |
cluster_name | The cluster to show sources from. If omitted, sources from all clusters are shown. For available clusters, see SHOW CLUSTERS . |
Details
Output format for SHOW SOURCES
SHOW SOURCES
’s output is a table, with this structure:
name | type | cluster
------+------+--------
... | ... | ...
Field | Meaning |
---|---|
name | The name of the source. |
type | The type of the source: kafka , postgres , load-generator , progress , or subsource . |
cluster | The cluster the source is associated with. |
Examples
SHOW SOURCES;
name | type | cluster
--------------------+----------+---------
my_kafka_source | kafka | c1
my_postgres_source | postgres | c2
SHOW SOURCES IN CLUSTER c2;
name | type | cluster
-------------------+----------+--------
my_postgres_source | postgres | c2