MSCEWI5021

MATERIALIZED QUERY IS NOT SUPPORTED

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

Severity

High

Description

The use of Materialized Query is not supported in Snowflake

Example Code

Input Code:

CREATE TABLE TRANSCNT (ACCTID, LOCID, YEAR, CNT) AS
  (SELECT ACCOUNTID, LOCATIONID, YEAR, COUNT(*)
     FROM TRANS
     GROUP BY ACCOUNTID, LOCATIONID, YEAR )
     DATA INITIALLY DEFERRED
     REFRESH DEFERRED
     MAINTAINED BY SYSTEM
     ENABLE QUERY OPTIMIZATION;

Output Code:

CREATE TABLE TRANSCNT (ACCTID, LOCID, YEAR, CNT) AS
  (SELECT ACCOUNTID, LOCATIONID, YEAR, COUNT(*)
     FROM
    TRANS
     GROUP BY ACCOUNTID, LOCATIONID, YEAR )
----** MSC-ERROR - MSCEWI5021 - MATERIALIZED QUERY IS NOT SUPPORTED **
--     DATA INITIALLY DEFERRED
--     REFRESH DEFERRED
--     MAINTAINED BY SYSTEM
--     ENABLE QUERY OPTIMIZATION
                              ;

Recommendations

• If this error happens is because there is no Snowflake equivalent for the node that is being converted.

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