Materialize Documentation
Join the Community github/materialize

SHOW SOURCES

SHOW SOURCES returns a list of all sources available to your Materialize instances.

Syntax

SHOW SOURCES FROM schema_name
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, or load-generator
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