By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Zero-ETL Integrations Feature

0

Is it currently possible to use Zero-ETL Integrations between Aurora PostgreSQL and Redshift. These Database Instances are in 2 different AWS Account.

If this is not possible, how do I replicate the Table/Data from Aurora PostgreSQL to Redshift with very low Data Latency. Any suggestions?

Topics
DatabaseAnalytics
Tags
Aurora PostgreSQLDatabaseAmazon Redshift
Language
English
rePost-User-2571194
asked 7 months ago397 views
1 Answer
0

Hello.

If you check the preview document below, it seems that Aurora PostgreSQL does not support it yet.
https://docs.aws.amazon.com/redshift/latest/mgmt/zero-etl.reqs-lims.html

Your source DB cluster must be running Aurora MySQL version 3.03.1 (compatible with MySQL 8.0.26) or higher. Aurora PostgreSQL is not currently supported.

Although it is not a replication, you can search Aurora PostgreSQL data from Redshift by running a federated query.
https://docs.aws.amazon.com/redshift/latest/dg/getting-started-federated.html

If you want to migrate data, I think you can use DMS or Glue.

profile picture
EXPERT
Riku_Kobayashi
answered 7 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content