SSC-EWI-0008

COLLATE clause may have a different behavior in Snowflake

Severity

Medium

Description

This warning is added when the collate clause is used as a column option because it is supported in Snowflake but may behave differently in the collate specification. Please review the collate documentation in order to verify which specifiers are supported in Snowflake.

Example Code

Input Code:

IN -> PostgreSql_01.sql

CREATE TABLE TABLE01 (
    col1 text COLLATE "C"
);

Output Code:

OUT -> PostgreSql_01.sql

CREATE TABLE TABLE01 (
    col1 text
              !!!RESOLVE EWI!!! /*** SSC-EWI-0008 - COLLATE CLAUSE MAY HAVE A DIFFERENT BEHAVIOR IN SNOWFLAKE. ***/!!! COLLATE "C"
);

Recommendations

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