Snowflake Dynamic Tables

Snowflake Dynamic Tables can be used to create a materialized view on top of the inserted append-only data to create a final state view of the data, i.e. most recent records only.

At present, we provide you the scripts to run to create these views by visiting the Views tab within a destination

Or by viewing the schema and clicking Views on the topic menu

Additional functionality will be delivered soon that will provide for more flexibility and the automatic deployment/managment of these views within Snowflake.

Learn more at Snowflake Dynamic Tables