How to add upsert in Postgres flexi server

Question

Hi,

We implemented copied data from source to destination by following this link.

https://learn.microsoft.com/en-us/answers/questions/1351963/how-we-can-implement-cdc-or-copied-data-from-sourc

Our source and destination are Postgres Flexi server and SHIR is being used.

Therefore, moved to watermark approach. However, facing other issue

When update the source data. It is not being to allow to update the existing row sink data.

Upsert option is not available here. Please guide us to add update existing row sink data changes.

Answer 1

Hello @Kanwar, Pramod

I am checking the document!

Did you try the Upsert functionality?

By using the "Upsert" transformation in the copy activity, you can insert new rows or update existing rows.

you can use the "Upsert" sink transformation in the copy activity. The "Upsert" transformation allows you to insert new rows or update existing rows based on a matching condition.