AWS – Amazon Redshift announces automatic refresh and query rewrite for materialized views
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.
Read More for the details.