Amazon Aurora PostgreSQL zero-ETL integration with Amazon Redshift now supports multiple integrations

Today, we are excited to announce that Amazon Aurora PostgreSQL zero-ETL integration with Amazon Redshift now supports up to five integrations from the same Aurora cluster. This enhancement allows customers to create multiple zero-ETL integrations between a single Amazon Aurora PostgreSQL cluster and same or different Amazon Redshift warehouses, providing greater flexibility and efficiency in data analytics workflows.

With this new capability, customers can now seamlessly replicate data from a single Aurora PostgreSQL cluster to multiple Redshift environments without the need for complex extract, transform, and load (ETL) processes. This feature is particularly beneficial for organizations that require different data views or aggregations for various analytical purposes, such as departmental reporting, regional analysis, or specific project requirements. By supporting multiple integrations, customers can maintain a single source of truth in Aurora while distributing relevant data subsets to different Redshift warehouses, optimizing both storage and query performance.

Amazon Aurora PostgreSQL zero-ETL integration with Amazon Redshift is available for Aurora PostgreSQL version 16.4 and higher in the regions listed here.

To learn more and get started with zero-ETL integration, visit Amazon Aurora zero-ETL integration with Amazon Redshift and the getting started guides for Aurora and Amazon Redshift.