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달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠