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