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?
Amazon AppStream 2.0 users can now save their user preferences between streaming sessions
about 7 hours ago
Services
Share
Read update
Services
Share
Read update
Services
Share
AWS announces new AWS Direct Connect location in Osaka, Japan
about 11 hours ago
Services
Share
Amazon DynamoDB announces support for FIPS 140-3 interface VPC and Streams endpoints
about 11 hours ago
Services
Share