General Conversion Settings

General Settings for SnowConvert

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

Materialized views conversion settings

On this page, you will find several options to help customize the parameters of the Materialized Views to Dynamic Tables translation, generated on your conversion.

Placeholder WIP screen

To maintain the most complete functionality for Materialized Views or in the case of Teradata's Join Indexes, SnowConvert generates Dynamic Tables instead of using a one-to-one Materialized View (or a Join Index to Materialized View), this happens because in other languages Materialized Views have configurations that Snowflake does not. For more information about Snowflake's Materialized Views limitations, please check Materialized Views Limitations.

Transformation

The settings defined here will be used for every instance of Dynamic Table generated in the conversion.

Dynamic Table Conversion Settings:

• Target Lag: Specifies the maximum time the dynamic table's content should lag related to the base table’s updates. For example: specify 5 minutes if the data in the dynamic table should lag by no more than 5 minutes.

• Warehouse: Specifies the name of the Warehouse that provides the compute resources for refreshing the dynamic table. You must have the USAGE privilege on this warehouse to create the dynamic table. By default, Snowconvert will use a placeholder value.

For more information, you can check the Snowflake Dynamic Table documentation.

Teradata JOIN INDEX behaves in the same manner as the MATERIALIZED VIEWS.