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
Updated 17 days ago