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