Amazon Redshift supports auto and incremental refresh of Materialized Views for zero-ETL integrations
Share
Services
Today, Amazon Redshift announced the support for automatically and incrementally refreshable materialized views (MVs) on tables in a zero-ETL integration. This new feature eliminates the need for full refreshes, which previously required re-executing underlying select statements and rewriting all data in the MV.
With this launch, you can leverage the power of zero-ETL integrations with automatically and incrementally refreshable MVs, enabling more efficient data updates and faster query responses. This feature automatically keeps MVs up-to-date as the underlying data changes, eliminating the need for manual refresh operations or complex ETL processes. Organizations handling high-volume, dynamic datasets can now access near real-time insights while significantly reducing their operational workload.
To learn more and get started with zero-ETL integration, visit the getting started guides for [Amazon Redshift](https://docs.aws.amazon.com/redshift/latest/mgmt/zero-etl-using.html). To learn more about refreshing a materialized view, visit the [documentation](https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-refresh.html).
What else is happening at Amazon Web Services?
Read update
Services
Share
Amazon GuardDuty Malware Protection for S3 announces price reduction
February 6th, 2025
Services
Share
Amazon Keyspaces is now available in Africa (Cape Town) Region
February 6th, 2025
Services
Share
Amazon ECS Service Connect is now available in the AWS GovCloud (US-West) and AWS GovCloud (US-East) Regions
February 5th, 2025
Services
Share
Amazon SageMaker AI is now available in Asia Pacific (Malaysia)
February 5th, 2025
Services
Share
Amazon DocumentDB now offers one-click connectivity with CloudShell
February 5th, 2025
Services
Share