Materialize Logo

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

SHOW SOURCES's output is a table with one column, name.

Changed in v0.5.0: The output column is renamed from SOURCES to name.

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 using:

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

SHOW SCHEMAS;
public
SHOW SOURCES FROM public;
my_stream_source
my_file_source
SHOW SOURCES;
my_stream_source
my_file_source