MSCEWI2016

Global temporary table functionality not supported.

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

Severity

Low

Description

This message is shown when SnowConvert finds a Create Table with the GLOBAL TEMPORARY option. Since it is not supported in Snowflake, it is removed and a message is added.

Code Example

Input Code:

CREATE GLOBAL TEMPORARY TABLE TableExample
(
ColumnExample Number
)

Output Code:

/*** MSC-WARNING - MSCEWI2016 - GLOBAL TEMPORARY TABLE FUNCTIONALITY NOT SUPPORTED ***/
CREATE TABLE PUBLIC.TableExample
(
ColumnExample Number(38, 19)
);

Recommendations

• No additional user actions are required.

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