data-engineering-interview-questions
data-engineering-interview-questions copied to clipboard
materialized views in Amazon Redshift
https://github.com/OBenner/data-engineering-interview-questions/blob/master/content/redshift.md#can-you-create-materialized-views-in-amazon-redshift
No, Amazon Redshift does not support materialized views. However, you can use other techniques like precomputing and storing intermediate query results to achieve similar performance improvements.
but https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-overview.html