Links

MSCEWI1092

Materialized View was converted to regular View

Severity

Low

Description

Snowflake Materialized Views have certain limitations mentioned here. Right now, all Materialized Views are being converted to regular Views without the additional clauses they had. In the future, SnowConvert is going to convert the supported cases to Snowflake Materialized Views.

Example Code

Input Code

CREATE MATERIALIZED VIEW MATERIALIZED_VIEW1
SEGMENT CREATION IMMEDIATE
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
INMEMORY PRIORITY NONE MEMCOMPRESS FOR QUERY LOW DISTRIBUTE AUTO NO DUPLICATE
AS
select
*
from
aTable;

Output Code

/*** MSC-WARNING - MSCEWI1092 - MATERIALIZED VIEW WAS CONVERTED TO REGULAR VIEW. ***/
CREATE OR REPLACE VIEW PUBLIC.MATERIALIZED_VIEW1
AS
select
*
from
PUBLIC.aTable;

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.