SSC-EWI-0008

COLLATE clause may have a different behavior in Snowflake

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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 [email protected]