Unlock this content
Enter your email to unlock this content for free
What's a Materialized View
Materialized views are insert triggers that automatically transform data as it's ingested. They execute a query on each insert and save the results to a target table, allowing you to preprocess data at insert time rather than query time.
What is a Materialized View?
A materialized view is the continuous streaming result of a query saved as a new table. As new data is ingested into a source table, a transformation query executes automatically and saves the transformed results in a target table that you can query like any other table.
This happens at insert time, which is why materialized views are also called insertion triggers. Unlike regular views (which are just saved queries that execute at query time), materialized views store actual data that's computed and updated automatically as new data arrives.
Incremental Processing: Materialized views process only new data as it's inserted, not the entire table. Each insert triggers the query to process only the new rows.