sqlglot.errors.ParseError: Required keyword: 'this' missing for <class 'sqlglot.expressions.CommentColumnConstraint'>

[vedas2]

Hi,

I've a snowflake sql looks like this:
create or replace view my_view
(
"USER_ID" COMMENT "TODO",
"GUEST_IND" COMMENT "TODO",
...
)

Sqlglot fails to parse with this error:

sqlglot.errors.ParseError: Required keyword: 'this' missing for <class 'sqlglot.expressions.CommentColumnConstraint'>. Line 8, Col: 25.
  E;
  create or replace   view SANDBOX_DB_PII.dwh.dim_user
  
(
  
    "USER_ID" COMMENT "TODO", 

Any pointers?

[tobymao]

can you put a fully reproducible code snippet please

[tobymao]

snowflake documentation shows that comments need to be string literals, but you're using double quotes which is an identifier

https://docs.snowflake.com/en/sql-reference/sql/create-table

[vedas2]

After narrowing down the problem It seems like the issue is with copy grants statement. I have a SQL query like

alter session set ABORT_DETACHED_QUERY = TRUE;
create or replace view my_view
(
    "USER_ID", 
    "GUEST_IND",
    "FIRST_ORDER_DATE_TIME_UTC"  
) 
copy grants
AS (
SELECT
    USER_ID,
    GUEST_IND,
    FIRST_ORDER_DATE_TIME_UTC
FROM
    (select * from __dbt__cte__user_base LIMIT 0)  
  );

This fails to parse with error:

sqlglot.errors.ParseError: Invalid expression / Unexpected token. Line 9, Col: 1.
ate or replace view my_view
(
  "USER_ID", 
  "GUEST_IND",
  "FIRST_ORDER_DATE_TIME_UTC"  
) 
copy grants
AS (
SELECT
  USER_ID,
  GUEST_IND,
  FIRST_ORDER_DATE_TIME_UTC
FROM
  (select * fro
  ```
  
If I remove `copy grants` from the query it works. Since this is a valid snowflake query, it should be supported.
The problem differs from the original issue reported, I can create a new issue.