MSCEWI2015

Set 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 SET option. Since the SET TABLE is not supported in Snowflake, it is removed and a message is added.

For more information check Different SQL Table Definitions in Teradata & Snowflake

Code Example

Input Code:

CREATE SET TABLE TableExample
(
ColumnExample Number
)

CREATE SET VOLATILE TABLE SOMETABLE, LOG AS 
(SELECT BUS_PLAN_MEAS_DTL_ROW_ID
, BUS_PLAN_TYP_CD
, MEAS_PLAN_TYP_CD
, MEAS_SUB_PLAN_TYP_CD
, WSLR_PARTY_ID FROM T2);

Output Code:

/*** MSC-WARNING - MSCEWI2015 - SET TABLE FUNCTIONALITY NOT SUPPORTED. TABLE MIGHT HAVE DUPLICATE ROWS ***/
CREATE TABLE PUBLIC.TableExample
(
ColumnExample Number(38, 19)
);

/*** MSC-WARNING - MSCEWI2015 - SET TABLE FUNCTIONALITY NOT SUPPORTED. TABLE MIGHT HAVE DUPLICATE ROWS ***/
CREATE TEMPORARY TABLE DATAWAREHOUSE.PUBLIC.SOMETABLE AS
(SELECT
BUS_PLAN_MEAS_DTL_ROW_ID,
BUS_PLAN_TYP_CD,
MEAS_PLAN_TYP_CD,
MEAS_SUB_PLAN_TYP_CD,
WSLR_PARTY_ID
FROM DATAWAREHOUSE.PUBLIC.T2) ;

Recommendations

• No additional user actions are required.

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