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
Read update
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