Can upserts be performed from one Aurora Postgres database to another via Glue?

Question

I am trying to set up a Glue Job that automatically crawls a source Aurora RDS Postgres instance and writes it another instance in a different cluster. 
I was able to perform an initial copy/load via the Glue Catalog. 
The Visual ETL job was pretty easily able to load from the source instance's catalog to the target instance's catalog and consequently into the target RDS instance itself. However, this was a straight copy... and I am wondering if there is a way to incorporate upsert logic into this ?

Thank you

Answer

Normally that's done writing into a temporary table and then asking the DB to do an UPSERT/MERGE issuing that command separately.   
In the case of a visual job, it would involve a custom code component that does that.

Can upserts be performed from one Aurora Postgres database to another via Glue?

相关内容