MSCEWI2015
Set table functionality not supported.
Low
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.
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);
/*** 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) ;
- 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.
Last modified 1yr ago