Posted On: Nov 28, 2023

Amazon Aurora zero-ETL integration with Amazon Redshift enables near real-time analytics and machine learning (ML) using Amazon Redshift on petabytes of transactional data from Amazon Aurora. Amazon Aurora PostgreSQL-Compatible Edition database clusters can now be used (in public preview) as a source for zero-ETL integrations. Within seconds of transactional data being written into Aurora, the data is available in Amazon Redshift. You don’t have to build and maintain complex data pipelines to perform extract, transform, and load (ETL) operations.

Aurora zero-ETL integration with Amazon Redshift helps you derive holistic insights across many applications, and break data silos in your organization. Quickly analyze data from an Aurora database cluster in an Amazon Redshift warehouse. Enhance data analysis with the rich analytics capabilities of Amazon Redshift, such as high-performance SQL, built-in ML and Spark integrations, materialized views, data sharing, and direct access to multiple data stores and data lakes.

Aurora PostgreSQL zero-ETL integration with Amazon Redshift is now available in public preview for Aurora PostgreSQL 15.4 in the US East (Ohio) Region for Amazon Aurora provisioned as well as Amazon Redshift Serverless and RA3 instance types.

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