Posted On: Mar 20, 2024
HAQM Aurora MySQL zero-ETL integration with HAQM Redshift now supports data filtering, enabling you to include or exclude specific databases and tables as part of the zero-ETL integration. Based on your analytics needs, filtering of specific databases and tables helps you selectively bring data into HAQM Redshift. In addition, you can now easily manage and automate the configuration and deployment of resources needed for an Aurora MySQL zero-ETL integration with HAQM Redshift using AWS CloudFormation.
HAQM Aurora MySQL zero-ETL integration with HAQM Redshift enables you to run near real-time analytics and machine learning (ML) using HAQM Redshift to analyze petabytes of transactional data from HAQM Aurora MySQL. With data filtering, you can 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. These include integrated machine learning and Spark support, materialized views, data sharing capabilities, and direct access to multiple data stores and data lakes.
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 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 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, read our blog post. To learn more about using CloudFormation templates with the zero-ETL integration, visit the user guide.