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:

PostgreSql

IN -> PostgreSQL_01.sql

COMMENT ON RULE rule_name on TABLE_NAME IS 'this is a comment';

Output Code:

Snowflake

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

• If you need more support, you can email us at [email protected]