MSCEWI3024

Table properties were removed because Snowflake does not require them.

Severity

Low

Description

A table property was removed because is not necessary for Snowflake.

Example Code

Input Code:

CREATE TABLE TABLE1 (
   col1 NUMBER,
   col2 XMLTYPE REFERENCES T1 (col1)
)
XMLTYPE warehouse_spec STORE AS BINARY XML (
    TABLESPACE example
    STORAGE (INITIAL 6144 NEXT 6144)
    CHUNK 4000
    NOCACHE LOGGING
);

Output Code:

CREATE OR REPLACE TABLE PUBLIC.TABLE1 /*** MSC-WARNING - MSCEWI3024 - TABLE PROPERTIES REMOVED BECAUSE SNOWFLAKE DOES NOT REQUIRE THEM. ***/
 (
 col1 NUMBER (38,19),
 col2 XMLTYPE REFERENCES PUBLIC.T1 (col1));

Recommendations