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)​

MASKING POLICY

NETWORK POLICY

Last modified 1yr ago