Amazon Redshift announces support for cascading refresh of nested materialized views
News
Amazon Redshift has introduced support for cascading refresh of nested materialized views (MVs), enhancing data analytics capabilities across local tables and external streaming sources like Kinesis and Kafka.
- Introduces 'cascade' and 'restrict' refresh options for nested materialized views
- Enables automatic multi-level MV refreshes in a single transaction
- Simplifies complex refresh logic for nested materialized view hierarchies
- Supports refreshing MVs connected to local Redshift tables and external streaming sources
- Allows incremental updates while maintaining dependency relationships
This feature streamlines application development by automating the refresh process for complex analytics pipelines, reducing manual coordination efforts.
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
Jul 15
2025
2025
Amazon Redshift announces support for automatic refresh of materialized views on Apache Iceberg tables
Jul 11
2025
2025
Harnessing the Power of Nested Materialized Views and exploring Cascading Refresh
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
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.