SHOW SOURCES
NOTE!
For improved performance, execute this command in the
mz_introspection
cluster. To switch clusters, use SET CLUSTER = mz_introspection;
.
SHOW SOURCES
returns a list of all sources available to your Materialize
instances.
Syntax
Field | Use |
---|---|
schema_name | The schema to show sources from. Defaults to public in the current database. 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. |
Internal statistic sources
Materialize comes with a number of sources that contain internal statistics
about the instance’s behavior. These are kept in a “hidden” schema called
mz_catalog
.
To view the internal statistic sources use:
SHOW SOURCES FROM mz_catalog;
To select from these sources, you must specify that you want to read from the
source in the mz_catalog
schema.
Examples
Default behavior
SHOW SCHEMAS;
name
--------
public
SHOW SOURCES FROM public;
name | type
--------------------+---------
my_kafka_source | kafka
my_postgres_source | postgres
SHOW SOURCES;
name | type
--------------------+---------
my_kafka_source | kafka
my_postgres_source | postgres