Amazon Redshift now supports incremental refresh on Materialized Views (MVs) for data lake tables
News
Amazon Redshift now supports incremental refresh of Materialized Views (MVs) on data lake tables, allowing customers to maintain up-to-date data more efficiently and cost-effectively.
Specifically, the article covers:
- Incremental refresh for MVs helps improve query performance for data lake queries
- Data lake tables with Open Table Formats (OTFs) like Apache Iceberg have continuously changing data
- Previously, full re-compute of MVs was required for changing data
- Now, Redshift identifies changes in base data lake tables and only reads the changed portion from S3
- This saves cost and time for eligible MVs
- The feature is available in all commercial regions
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
Nov 8
2024
2024
Incremental refresh for Amazon Redshift materialized views on data lake tables
Dec 13
2024
2024
Amazon Redshift supports auto and incremental refresh of Materialized Views for zero-ETL integrations
Jul 16
2025
2025
Amazon Redshift announces support for cascading refresh of nested materialized views
Jul 15
2025
2025
Amazon Redshift announces support for automatic refresh of materialized views on Apache Iceberg tables
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.