SSC-EWI-0080

Default value is not allowed on binary columns

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

Low

Description

This EWI is added when the source code has a default value for BINARY data type, which is not supported in SnowFlake SQL

Example Code

Input Code (SqlServer):

IN -> SqlServer_01.sql

create table test1345
(
  key1 binary default 0
);

Output Code:

OUT -> SqlServer_01.sql

CREATE OR REPLACE TABLE test1345
(
  key1 BINARY
              !!!RESOLVE EWI!!! /*** SSC-EWI-0080 - DEFAULT VALUE IS NOT ALLOWED ON BINARY COLUMNS ***/!!!
              default 0
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"transact"}}'
;

Recommendations

• If you need more support, you can email us at [email protected]