Incremental refresh for Amazon Redshift materialized views on data lake tables
Big Data Blog
This article introduces the ability to incrementally refresh materialized views on data lake tables, including open file formats like Apache Iceberg, in Amazon Redshift. Materialized views speed up queries on large tables by storing precomputed results.
Specifically, the article covers:
- Prerequisites for trying out incremental materialized view refresh
- Step-by-step instructions for incremental refresh on standard data lake tables
- Step-by-step instructions for incremental refresh on Apache Iceberg data lake tables
- Performance improvements seen with incremental refresh compared to full recompute, based on benchmarking
- Cleanup steps to remove created resources
- Conclusion highlighting the benefits and encouraging use of this new feature
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Oct 30
2024
2024
Amazon Redshift now supports incremental refresh on Materialized Views (MVs) for data lake tables
Dec 13
2024
2024
Amazon Redshift supports auto and incremental refresh of Materialized Views for zero-ETL integrations
Jul 15
2025
2025
Amazon Redshift announces support for automatic refresh of materialized views on Apache Iceberg tables
Jul 16
2025
2025
Amazon Redshift announces support for cascading refresh of nested materialized views
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.