Amazon Redshift now supports automatic refresh of materialized views that are defined on external Apache Iceberg tables in the Amazon S3 data lake.
With this update, Amazon Redshift will automatically refresh a materialized view defined on Apache Iceberg tables, that reside in the Amazon S3 bucket of the Amazon data lake, when there is new data is added or deleted to the Apache Iceberg tables.
You can start using this new capability immediately to build more complex and flexible analytics pipelines in the Amazon S3 data lake. To learn more about automatic refresh of materialized views and to get started with using materialized views in Amazon Redshift, refer to the Autorefreshing a materialized view sub-section of the Refreshing a materialized view section of the Amazon Redshift Materialized Views documentation.
Source:: Amazon AWS