SSC-FDM-0031

Dynamic Table required parameters set by default

Description

Materialized Views (and Join Indexes in the case of Teradata) are migrated to Dynamic Tables in Snowflake. Dynamic Tables require two parameters to be set: TARGET_LAG and WAREHOUSE.

If these parameters are not set in the configuration options, they are set by default during conversion.

Read more about the required Dynamic Tables parameters here.

Example Code

Input Code (Oracle):

IN -> Oracle_01.sql
CREATE MATERIALIZED VIEW mv1
AS SELECT * FROM table1;

Output Code:

OUT -> Oracle_01.sql
CREATE OR REPLACE DYNAMIC TABLE materialized_view1
--** SSC-FDM-0031 - DYNAMIC TABLE REQUIRED PARAMETERS SET BY DEFAULT **
TARGET_LAG='1 day'
WAREHOUSE=UPDATE_DUMMY_WAREHOUSE
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"oracle"}}'
AS
  SELECT column1, column2 FROM
    table1;

Recommendations

Last updated