Posted On: Apr 2, 2024
Amazon Aurora MySQL zero-ETL integration with Amazon Redshift is now supported in 11 additional regions, enabling near real-time analytics and machine learning (ML) using Amazon 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 Amazon 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 Amazon Redshift. Multiple filters can be applied to the zero-ETL integration, allowing you to tailor the replication to your specific needs and leverage Amazon Redshift's powerful analytical functionalities.
Amazon Aurora MySQL zero-ETL integration with Amazon 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 Amazon Aurora zero-ETL integration with Amazon Redshift and the getting started guides for Aurora and Amazon Redshift. To learn more and get started with data filtering, visit this post.