Posted On: Nov 11, 2020

Amazon Redshift, a fully-managed cloud data warehouse, now supports automatic refresh and query rewrite capabilities to simplify and automate the usage of materialized views. The automatic refresh feature helps administrators to keep materialized views up-to-date, while the automatic query rewrite feature enables end-users to easily benefit from improved query performance.

Materialized views provide significantly faster query performance for repeated and predictable analytical workloads such as dashboarding, queries from business intelligence (BI) tools, and ELT (Extract, Load, Transform) data processing. Materialized views store pre-computed results for related queries, and need to be refreshed to reflect changes to the relevant tables they’re based on. Amazon Redshift now automatically refreshes materialized views while serving additional workloads, simplifying the usage of up-to-date materialized views to accelerate query performance. The automatic query rewrite capability leverages one or more relevant materialized views and can improve query performance by order(s) of magnitude using existing materialized views, even in cases where the specific materialized views aren’t explicitly referenced in user queries.

The support for automatic refresh and query rewrite for materialized views in Amazon Redshift is included with release version 1.0.20949 or later. This functionality is available to all new and existing customers at no additional cost. To get started and learn more, visit our documentation. Refer to the AWS Region Table for Amazon Redshift availability.