SSC-FDM-OR0006

Constraint state removed from not null inline constraint.

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 [e-mail]