Posted On: Jun 6, 2022

Automated Materialized View (AutoMV) for Amazon Redshift helps lower query latency for repeatable workloads like dashboard queries minimizing the effort for manually creating and managing materialized views.

Materialized Views are a powerful tool for improving query performance but they require careful workload monitoring and analysis to determine where they may provide the best returns. This may take hours to days and require performance tuning knowledge. Additionally, increasing and changing workloads results in continual monitoring by users.

AutoMV in Amazon Redshift continually monitors the workload using machine learning to decide whether a new materialized view will be beneficial. AutoMV balances the cost of creating and keeping materialized views up-to-date vs expected improvements to query latency. The system also monitors previously created AutoMVs and drops them when they are no longer beneficial to the workload. This avoids expending resources to keep unused AutoMVs fresh.

Amazon Materialized View preview is available in Amazon Web Services China (Beijing) Region, operated by Sinnet and Amazon Web Services China (Ningxia) Region, operated by NWCD. Please note, preview features are provided primarily for evaluation and testing purposes. They should not be used in production systems or with production data. For preview terms and conditions, see Beta Service Participation in Sinnet Service Terms for Amazon Web Services (Beijing Region) or Western Cloud Data Service Terms for Amazon Web Services (Ningxia Region). To learn more about AutoMV, please visit the documentation. If you have any questions or concerns, please contact the Amazon Web Services China Support.