Amazon Aurora zero-ETL Integration with Amazon Redshift

Enable near real-time analytics on petabytes of transactional data
Get started with zero-ETL integrations
Contact Support

Why Aurora zero-ETL integration with Amazon Redshift?

Amazon Aurora zero-ETL integration with Amazon Redshift enables near real-time analytics and machine learning (ML) using Amazon Redshift on petabytes of transactional data. Within seconds of transactional data being written into Amazon Aurora, zero-ETL seamlessly makes the data available in Amazon Redshift, removing the need to build and manage complex data pipelines that perform extract, transform, and load (ETL) operations.

Benefits

Access transactional data from Aurora in Amazon Redshift within seconds to run near real-time analytics and ML on petabytes of data.

Quickly analyze your transactional data in near real time without having to build and manage ETL pipelines to move transactional data to analytics systems.

Consolidate multiple tables from various Aurora database clusters and replicate your data to one Amazon Redshift data warehouse to run unified analytics across multiple applications and data sources.

Run near real-time analytics on transactional data without having to manage any infrastructure when using both Amazon Aurora Serverless v2 and Amazon Redshift Serverless.

Use cases

Use Amazon Redshift analytics and ML capabilities to derive insights in near real time from transactional and other data to effectively respond to critical, time-sensitive events. Near real-time analytics can help you get more accurate and timely insights for use cases such as content targeting, optimized gaming experience, data quality monitoring, fraud detection, and customer behavior analysis.

With the Aurora zero-ETL integration with Amazon Redshift, you can use Amazon Redshift capabilities to analyze petabytes of your transactional data consolidated from multiple Aurora database clusters. You can take advantage of the comprehensive analytical capabilities of Amazon Redshift, such as built-in ML, materialized views, data sharing, and federated access to multiple data stores and data lakes. With Amazon Redshift ML, you can run billions of predictions with straightforward SQL commands with native integration into Amazon SageMaker.

Moving data from a transactional database into a central data warehouse often requires building, managing, and operating a complex data pipeline ETL solution. With a zero-ETL integration, you can seamlessly replicate the schema, existing data, and data changes from your Aurora database to a new or existing Amazon Redshift cluster. Zero-ETL integration removes the need for complex data pipeline management.

How to get started

To create your zero-ETL integration between Aurora and Amazon Redshift, you specify an Aurora DB cluster as the data source and an Amazon Redshift data warehouse as the target. The integration replicates data from the source database into the target data warehouse. The data becomes available in Amazon Redshift within seconds, allowing data analysts to begin using Amazon Redshift analytics and ML functionality on the data. To learn more, please visit the getting started guides for Aurora and Amazon Redshift.

Resources

Blog

Getting started guide for near real-time operational analytics using Amazon Aurora zero-ETL integration with Amazon Redshift

Read the blog
Blog

Create an Amazon Aurora MySQL zero-ETL integration with Amazon Redshift

Read the blog
Blog

Announcing data filtering for Amazon Aurora MySQL zero-ETL integration with Amazon Redshift

Read the blog
Video

Getting started with Amazon Aurora zero-ETL integration with Amazon Redshift

Watch the video
Video

Amazon Aurora PostgreSQL zero-ETL Integration with Amazon Redshift Demo

Watch the video
Video

Analyze Amazon Aurora PostgreSQL data in Amazon Redshift with zero-ETL

Watch the video
Video

Learn how Intuit leverages zero-ETL to get near real-time insights

Watch the video
Blog

With a zero-ETL approach, AWS is helping builders realize near-real-time analytics

Read the blog
Podcast

Amazon Aurora MySQL zero-ETL integration with Amazon Redshift

Listen to the podcast

Pricing

AWS does not charge an additional fee for Aurora zero-ETL integration with Amazon Redshift. You pay for existing Aurora and Amazon Redshift resources used to create and process the change data generated as part of a zero-ETL integration. These resources could include:

  • Additional I/O and storage used by enabling change data capture
  • Snapshot export costs for the initial data export to seed your Amazon Redshift databases
  • Additional Amazon Redshift storage for storing replicated data
  • Additional Amazon Redshift compute for processing data replication
  • Cross-AZ data transfer costs for moving data from source to target.

Ongoing processing of data changes by zero-ETL integration is offered at no additional charge. For more information, please visit the Aurora pricing page. 

Customers