SSC-EWI-PG0009

Comment on 'Type' is not supported by Snowflake.

Severity

Low

Description

In the original code, there are various objects that can receive comments. However, in Snowflake, several of these objects do not exist, and thus, comments cannot be assigned to them. The code for handling these scenarios is commented out to prevent any potential errors.

Code Example

Input Code:

IN -> PostgreSQL_01.sql
COMMENT ON RULE rule_name on TABLE_NAME IS 'this is a comment';

Output Code:

OUT -> PostgreSQL_01.sql
!!!RESOLVE EWI!!! /*** SSC-EWI-PG0009 - COMMENT ON 'RULE' IS NOT SUPPORTED BY SNOWFLAKE. ***/!!!
COMMENT ON RULE rule_name on TABLE_NAME IS 'this is a comment';

Recommendations

Last updated