SHOW OBJECTS
NOTE!
For improved performance, execute this command in the
mz_introspection cluster. To switch clusters, use SET CLUSTER = mz_introspection;.
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
| 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