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