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:
COMMENT ON TABLE mytable IS NULL;
Output Code:
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 [email protected]
Last updated