Posted On: Nov 7, 2023
Amazon Aurora MySQL zero-ETL integration with Amazon Redshift is now generally available, enabling near real-time analytics and machine learning (ML) using Amazon Redshift to analyze petabytes of transactional data from Amazon Aurora MySQL-Compatible Edition. Within seconds of transactional data being written into Aurora, the data is available in Amazon Redshift. You don’t need to build and maintain complex data pipelines to perform extract, transform, and load (ETL) operations. Amazon Aurora MySQL zero-ETL integration with Amazon Redshift is now available for Amazon Aurora Serverless v2 and Provisioned and Amazon Redshift Serverless and RA3 instance types.
Zero-ETL integration helps you derive holistic insights across many applications and break data silos in your organization, making it simpler to analyze data from one or multiple Aurora database clusters in an Amazon Redshift warehouse. Enhance your 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.
Amazon Aurora MySQL zero-ETL integration with Amazon Redshift is now available for Aurora MySQL 3.05 (compatible with MySQL 8.0.32) and higher in the US East (Ohio), US East (N. Virginia), US West (Oregon), Asia Pacific (Singapore), Asia Pacific (Sydney), Asia Pacific (Tokyo), Europe (Frankfurt), Europe (Ireland), and Europe (Stockholm) Regions.
To learn more and get started with zero-ETL integration, visit Amazon Aurora MySQL zero-ETL integration with Amazon Redshift and the getting started guides for Aurora and Amazon Redshift.