MATERIALIZED VIEW
Config path:
/<database>/<schema>/materialized_view/<name>.yaml
Example:
text: |-
SELECT id, name
FROM test_ext_table_1
is_secure: true
- 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)
- 1.If you include cluster_by, columns are also required.
- 2.
- 3.Invalid materialized views will be re-created automatically.
Last modified 1yr ago