Posted On: Apr 2, 2024

HAQM Aurora MySQL zero-ETL integration with HAQM Redshift is now supported in 11 additional regions, enabling near real-time analytics and machine learning (ML) using HAQM Redshift. Based on your analytics needs, you can include or exclude specific databases and tables from an existing or a new zero-ETL integration and selectively bring data into HAQM Redshift.

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 Aurora database clusters. Additionally, you can use data filtering to select the databases and tables to be replicated from Aurora to HAQM Redshift. Multiple filters can be applied to the zero-ETL integration, allowing you to tailor the replication to your specific needs and leverage HAQM Redshift's powerful analytical functionalities. 

HAQM Aurora MySQL zero-ETL integration with HAQM Redshift is available for Aurora MySQL version 3.05+ (compatible with MySQL 8.0.32) and higher in the US West (N. California), US West (Oregon), US East (Ohio), US East (N. Virginia), Asia Pacific (Mumbai), Asia Pacific (Seoul), Asia Pacific (Hong Kong), Asia Pacific (Osaka), Asia Pacific (Singapore), Asia Pacific (Sydney), Asia Pacific (Tokyo), Canada (Central), Europe (London), Europe (Paris), Europe (Milan), Europe (Frankfurt), Europe (Ireland), Europe (Stockholm), Middle East (Bahrain), Africa (Cape Town), and South America (Sao Paulo) Regions.

To learn more and get started with zero-ETL integration, visit HAQM Aurora zero-ETL integration with HAQM Redshift and the getting started guides for Aurora and HAQM Redshift. To learn more and get started with data filtering, visit this post