MSCEWI2016

Global temporary table functionality not supported.

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