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 

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