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?

preguntada hace 10 meses551 visualizaciones
1 Respuesta
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
EXPERTO
respondido hace 10 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas