SSC-FDM-OR0006

Constraint state removed from not null inline constraint.

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.

Description

This warning occurs when the not null column constraint contains one of the following Oracle constraint states as part of the column inline definition:

[ RELY | NORELY | RELY DISABLE | RELY ENABLE | VALIDATE | NOVALIDATE ]

Snowflake does not support these states; therefore, they will be removed from the NOT NULL inline constraint.

Example Code

Input Code:

IN -> Oracle_01.sql

CREATE TABLE Table1(
  col1 INT NOT NULL RELY
);

Output Code:

OUT -> Oracle_01.sql

CREATE OR REPLACE TABLE Table1 (
    col1 INT NOT NULL /*** SSC-FDM-OR0006 - CONSTRAINT STATE RELY REMOVED FROM NOT NULL INLINE CONSTRAINT ***/
  )
  COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
  ;

Recommendations

• No additional user actions are required.

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