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?

gefragt vor 10 Monaten540 Aufrufe
1 Antwort
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
EXPERTE
beantwortet vor 10 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen