CREATE MATERIALIZED VIEW
Last updated
Last updated
In Snowconvert, Redshift Materialized Views are transformed into Snowflake Dynamic Tables. To properly configure Dynamic Tables, two essential parameters must be defined: TARGET_LAG and WAREHOUSE. If these parameters are left unspecified in the configuration options, Snowconvert will default to preassigned values during the conversion, as demonstrated in the example below.
For more information on Materialized Views, click .
For details on the necessary parameters for Dynamic Tables, click .
The following is the SQL syntax to create a view in Amazon Redshift. Click to here to go to Redshifts specification for this syntax.
The BACKUP and AUTO REFRESH clauses are deleted since they are not applicable in a Snowflake's Dynamic Table
: Dynamic Table required parameters set by default