Posted On: Mar 12, 2020
Starting today, Amazon Redshift supports materialized views functionality. 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.
Using materialized views, you can store the pre-computed results of queries and efficiently maintain them by incrementally processing the latest changes made to the source tables. Subsequent queries referencing the materialized views use the pre-computed results to run much faster. Materialized views can be created based on one or more source tables using filters, projections, inner joins, aggregations, grouping, functions and other SQL constructs.
Data engineers can easily create and maintain efficient data processing pipelines with materialized views while seamlessly extending the performance benefits to data analysts and BI tools. Materialized views also make it easier to migrate to Amazon Redshift.