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?

feita há 10 meses540 visualizações
1 Resposta
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
ESPECIALISTA
respondido há 10 meses

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas