SHOW MATERIALIZED VIEWS
NOTE!
For improved performance, execute this command in the
mz_introspection cluster. To switch clusters, use SET CLUSTER = mz_introspection;.
SHOW MATERIALIZED VIEWS returns a list of materialized views being maintained
in Materialize.
Syntax
| Field | Use |
|---|---|
| schema_name | The schema to show materialized views from. Defaults to public in the current database. For available schemas, see SHOW SCHEMAS. |
| cluster_name | The cluster to show materialized views from. If omitted, materialized views from all clusters are shown. |
Examples
SHOW MATERIALIZED VIEWS;
name | cluster
--------------+----------
winning_bids | default
SHOW MATERIALIZED VIEWS LIKE '%bid%';
name | cluster
--------------+----------
winning_bids | default