SHOW SOURCES
SHOW SOURCES returns a list of all sources available in Materialize.
Syntax
SHOW SOURCES [ FROM <schema_name> ] [ IN CLUSTER <cluster_name> ]
| Option | Description |
|---|---|
| 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:
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