Materialize Documentation
Join the Community github/materialize

SHOW OBJECTS

SHOW OBJECTS returns a list of all objects available to your Materialize instances in a given schema. Objects include tables, sources, sinks, views, indexes, secrets and connections.

Syntax

SHOW OBJECTS FROM schema_name
Field Use
schema_name The schema to show objects from. Defaults to public in the current database. For available schemas, see SHOW SCHEMAS.

Details

Output format

SHOW OBJECTS will output a table with two columns, nameand type.

Examples

SHOW SCHEMAS;
  name
--------
 public
SHOW OBJECTS FROM public;
  name          | type
----------------+-------
my_table        | table
my_source       | source
my_view         | view
my_other_source | source
SHOW OBJECTS;
  name    | type
----------+-------
my_table  | table
my_source | source
my_view   | view