MSCEWI2015

Set table functionality not supported.

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.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI2014

MSCEWI2016

Last modified 1yr ago