Posted On: Nov 28, 2023
Amazon Relational Database Service (Amazon RDS) for MySQL zero-ETL integration with Amazon Redshift allows you to access transactional data from Amazon RDS for MySQL to run analytics and machine learning (ML) on petabytes of data in Amazon Redshift. With the zero-ETL integration, you don’t need to build and maintain complex data pipelines to perform extract, transform, and load (ETL) operations. The Amazon RDS for MySQL zero-ETL integration with Amazon Redshift is now available in public preview for Amazon Redshift Serverless and Amazon Redshift RA3 instance types.
An Amazon RDS for MySQL zero-ETL integration with Amazon RedshiftENnbsp;helps derive holistic insights across many applications and break data silos in your organization, making it simpler to analyze data from one or multiple Amazon RDS for MySQL instances in Amazon Redshift. Additionally, you can consolidate that data into the same Amazon Redshift cluster with data from other zero-ETL integrations, such as from Amazon Aurora and Amazon DynamoDB. Enhance data analysis with the rich analytics capabilities of Amazon 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.
Amazon RDS for MySQL zero-ETL integration with Amazon Redshift is now available in public preview for Amazon RDS for MySQL version 8.0.28 and higher in the US East (Ohio), US East (N. Virginia), US West (Oregon), Asia Pacific (Tokyo), and Europe (Ireland) AWS Regions.
To learn more, refer to the Amazon RDS User Guide and the Amazon Redshift Management Guide.