Zero-ETL Integrations Feature

Question

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?

Answer

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.

Zero-ETL Integrations Feature

Relevanter Inhalt