Amazon Redshift materialized views support external tables
Amazon Web Services FeedAmazon Redshift materialized views support external tables Amazon Redshift adds materialized view support for external tables. With this enhancement, you can create materialized views in Amazon Redshift that reference external data sources such as Amazon S3 via Spectrum, or data in Aurora or RDS PostgreSQL via federated queries.