MSCCP0002

GLOBAL TEMPORARY TABLE functionality not supported.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

Global temporary tables are considered a complex pattern, due to the fact they can come in several variations, as indicated in Snowflake's documentation.

Code Example

Input Code:

CREATE OR REPLACE GLOBAL TEMPORARY TABLE GLOBAL_TEMP_TABLE
(
    col3 INTEGER,
    col4 VARCHAR(50)
);

Output Code:

/*** MSC-WARNING - MSCCP0002 - GLOBAL TEMPORARY TABLE FUNCTIONALITY NOT SUPPORTED. ***/
CREATE OR REPLACE TABLE GLOBAL_TEMP_TABLE
(
    col3 INTEGER,
    col4 VARCHAR(50)
);

Recommendations

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