Posted On: Nov 7, 2023
HAQM Aurora MySQL zero-ETL integration with HAQM Redshift is now generally available, enabling near real-time analytics and machine learning (ML) using HAQM Redshift to analyze petabytes of transactional data from HAQM Aurora MySQL-Compatible Edition. Within seconds of transactional data being written into Aurora, the data is available in HAQM Redshift. You don’t need to build and maintain complex data pipelines to perform extract, transform, and load (ETL) operations. HAQM Aurora MySQL zero-ETL integration with HAQM Redshift is now available for HAQM Aurora Serverless v2 and Provisioned and HAQM 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 HAQM Redshift warehouse. Enhance your data analysis with the rich analytics capabilities of HAQM 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.
HAQM Aurora MySQL zero-ETL integration with HAQM 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 HAQM Aurora MySQL zero-ETL integration with HAQM Redshift and the getting started guides for Aurora and HAQM Redshift.