How can sub nested columns be accessed to create materialized views?

Jim is trying to create a materialized view in a data source with nested columns. He provided examples of queries that resulted in errors. Yufan Song suggested a corrected query.



Asked on Oct 11, 2023

  • To access sub nested columns in a materialized view, use the correct syntax for nested fields.
CREATE MATERIALIZED VIEW test AS SELECT (data).crm.Operation AS operation FROM crm;
Oct 12, 2023Edited by