SnowDDL
Search
K

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. 1.
    If you include cluster_by, columns are also required.
  2. 2.
    Maintenance of materialized views implicitly incurs additional costs.
  3. 3.
    Invalid materialized views will be re-created automatically.