MSC-PG0020

Comment on 'Type' is not supported by Snowflake.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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

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

Output Code:

Snowflake

-- ** MSC-WARNING - MSC-PG0020 - COMMENT ON 'RULE' IS NOT SUPPORTED. BY SNOWFLAKE. **
-- -- rule case
-- 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]