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

PreviousMASKING POLICYNextNETWORK POLICY

Last updated