Videos
In this demo, Green Leaf Data Architect, Jessica, walks through how Databricks materialized views work and explains the difference between incremental refresh and full refresh.
This session covers how materialized views are created, what happens behind the scenes during refresh, and why some materialized views may not qualify for incremental refresh without additional configuration.
Topics covered include:
- Databricks materialized views in a presentation-layer architecture
- Incremental refresh vs full refresh behavior
- Why materialized views do not automatically stay updated on their own
- The pipeline created behind the scenes for refresh operations
- Why materialized view creation must use a SQL warehouse
- Why row tracking affects incremental refresh eligibility
- Comparing read/write behavior between a regular table refresh and a materialized view refresh