RDS Zero ETL support Change data capture (CDC) or no
0
RDS Zero ETL support Change data capture (CDC) or no when replicate to AWS Redshift
- Tags
- Amazon Relational Database ServiceAmazon RedshiftAmazon Aurora zero-ETL integration with Amazon Redshift
- Language
- English
asked 2 years ago699 views
1 Answer
- Newest
- Most votes
- Most comments
1
Hi,
Yes, data changes are replicated in almost real-time like other CDC solution: see. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/zero-etl.html
An Amazon RDS zero-ETL integration with Amazon Redshift enables near real-time analytics
and machine learning (ML) using Amazon Redshift on petabytes of transactional data from RDS.
It's a fully managed solution for making transactional data available in Amazon Redshift after it
is written to an RDS database. Extract, transform, and load (ETL) is the process of combining data
from multiple sources into a large, central data warehouse.
A zero-ETL integration makes the data in your RDS database available in Amazon Redshift in near real-time.
Best,
Didier
Relevant content
asked 2 years ago
asked 2 years ago
how to check raw sync success or no?
Hi, you can monitor replication state and progress with https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/zero-etl.describingmonitoring.html#zero-etl.monitoring. You can fully automate this monitoring via the EventBridge events sent by the ETL. Thnaks for accepting my answer!