Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2024 02:29 PM
The following doc suggests the ability to add column comments during MV creation via the `column list` parameter.
Thus, the SQL code below is expected to generate a table where the columns `col_1` and `col_2` are commented; however, this is not the case.
Note that the underlying table for the MV, `my_streaming_table`, is a Streaming Table.
%sql
USE CATALOG my_catalog;
USE SCHEMA my_schema;
DROP MATERIALIZED VIEW IF EXISTS my_mv;
CREATE MATERIALIZED VIEW my_mv
(col_1 COMMENT 'Column 1', col_2 COMMENT 'Column 2')
COMMENT 'MV of a streaming table.'
AS (
SELECT col_1 , col_2 FROM my_streaming_table
)