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. |
Details
Output format for SHOW SOURCES
SHOW SOURCES’s output is a table, with this structure:
name | type | size
-------+------+-----
... | ... + ....
| Field | Meaning |
|---|---|
| name | The name of the source. |
| type | The type of the source: kafka, postgres, load-generator, or subsource. |
| size | The size of the source. Null if the source is created using the IN CLUSTER clause. |
Examples
SHOW SCHEMAS;
name
--------
public
SHOW SOURCES FROM public;
name | type | size
--------------------+----------+-------
my_kafka_source | kafka |
my_postgres_source | postgres |
SHOW SOURCES;
name | type | size
--------------------+----------+-------
my_kafka_source | kafka |
my_postgres_source | postgres |