SHOW VIEWS

SHOW VIEWS returns a list of views in your Materialize instances.

Syntax 

SHOW MATERIALIZED FULL VIEWS 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.
MATERIALIZED Only return materialized views, i.e. those with indexes. Without specifying this option, this command returns all views, including non-materialized views.
FULL Return details about your views.

Details 

Output format for SHOW FULL VIEW 

SHOW FULL VIEW’s output is a table, with this structure:

 VIEWS | TYPE | QUERYABLE | MATERIALIZED
-------+------+-----------+--------------
 ...   | ...  | ...       | ...
Field Meaning
VIEWS The name of the view
TYPE Whether the view was created by the user or the system
QUERYABLE Can the view process SELECT statements? You can always SELECT FROM... materialized views, but non-materialized views have a specific set of requirements.
MATERIALIZED Does the view have an in-memory index? For more details, see CREATE INDEX

Examples 

Default behavior 

SHOW VIEWS;
         VIEWS
-------------------------
 my_nonmaterialized_view
 my_materialized_view

Only show materialized views 

SHOW MATERIALIZED VIEWS;
        VIEWS
----------------------
 my_materialized_view

Show details about views 

SHOW FULL VIEWS
          VIEWS          | TYPE | QUERYABLE | MATERIALIZED
-------------------------+------+-----------+--------------
 my_nonmaterialized_view | USER | t         | f
 my_materialized_view    | USER | t         | t

In this case my_nonmaterialized_view would only be queryable if it depended on my_materialized_view, e.g.

CREATE VIEW my_nonmaterialized_view AS
    SELECT col2, col3 FROM my_materialized_view;