Posted On: Mar 20, 2024
Amazon Aurora MySQL zero-ETL integration with Amazon 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 Amazon 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 Amazon Redshift using AWS CloudFormation.
Amazon Aurora MySQL zero-ETL integration with Amazon Redshift enables you to run near real-time analytics and machine learning (ML) using Amazon Redshift to analyze petabytes of transactional data from Amazon Aurora MySQL. With data filtering, you can 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. These include integrated machine learning and Spark support, materialized views, data sharing capabilities, and direct access to multiple data stores and data lakes.
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 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 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, read our blog post. To learn more about using CloudFormation templates with the zero-ETL integration, visit the user guide.