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

0

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

1回答
0

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.

profile pictureAWS
エキスパート
回答済み 6ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ