Hi @bozhu, The issue you're experiencing seems to be a limitation of Materialized Views (MVs) created by Delta Live Tables (DLT). While the documentation for CREATE MATERIALIZED VIEW The syntax does mention the capability to add comments to columns via the column_comment parameter; this feature might not be fully supported for MVs created by DLT. The provided information does not explicitly state that column comments are not endorsed for MVs created by DLT. Still, it does outline several limitations and restrictions on how MVs can be managed.
For example, MVs do not support identity columns or surrogate keys, and you cannot run ad hoc OPTIMIZE or VACUUM commands against MVs. However, the issue with column comments is not explicitly mentioned. Since the error you're encountering is not directly addressed in the provided sources, it would be best to contact Databricks Support for further assistance.
Here are the sources used to provide this answer:
- [Docs: materialized-views](https://docs.databricks.com/sql/user/materialized-views.html)
- [Docs: sql-ref-syntax-ddl-create-materialized-view](https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-create-materialized-view.html)
- [Docs: index](https://docs.databricks.com/delta-live-tables/index.html)
