MSC-PG0021

NULL is converted to '' and may have a different behavior in Snowflake.

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

Severity

Low

Description

En the source language, the removal of a comment is accomplished using the term "NULL." However, in Snowflake, a comparable method for eliminating a comment involves assigning the value of an empty string '' to achieve the same effect. This approach ensures that the comment is effectively assigned to empty string with a similar effect.

Code Example

Input Code:

PostgreSQL

COMMENT ON TABLE mytable IS NULL;

Output Code:

Snowflake

COMMENT ON TABLE mytable IS '' /*** MSC-WARNING - MSC-PG0021 - NULL IS CONVERTED TO '' AND MAY HAVE A DIFFERENT BEHAVIOR IN SNOWFLAKE. ***/ ;

Recommendations

• If you need more support, you can email us at [e-mail]