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 mv1
--** 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
--** SSC-FDM-0001 - VIEWS SELECTING ALL COLUMNS FROM A SINGLE TABLE ARE NOT REQUIRED IN SNOWFLAKE AND MAY IMPACT PERFORMANCE. **
SELECT * FROM
table1;

Recommendations

• Configure the dynamic table required parameters according to your needs.

• If you need more support, you can email us at [e-mail]