MATERIALIZED VIEW

Config path: /<database>/<schema>/materialized_view/<name>.yaml

Example:

text: |-
  SELECT id, name
  FROM test_ext_table_1

is_secure: true

Schema

• columns (dict)

  • {key} (ident) - column name

  • {value} (str) - column comment

• text (str) - view text

• is_secure (bool) - is view secure

• cluster_by (list)

  • {items} (str) - SQL expressions for CLUSTER BY

• comment (str)

Usage notes

1. If you include cluster_by, columns are also required.

2. Maintenance of materialized views implicitly incurs additional costs.

3. Invalid materialized views will be re-created automatically.

Links

• CREATE MATERIALIZED VIEW

• SHOW MATERIALIZED VIEWS

• Working with Materialized Views

• Parser & JSON Schema (GitHub)