Maintained with ☕️ by
IcePanel logo

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).