This is a deprecated version of the SnowConvert documentation, please visit the official site .
A table property was removed because is not necessary for Snowflake.
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
);
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));