updating records using copy job?

[Jerome22]

Hi,

when Data copy will support updates and not just adding rows?

I have a lot of tables which can have updated records, so I want to update my destination not just adding new rows.

thanks.

[v-sdhruv]

Hi @Jerome22 ,

Unfortunately, in Microsoft Fabric, the Copy Data activity does support an "Upsert" behavior. You can however use workarounds like Dataflows or SQL logic.
You can refer-
upsert option missing in copy activity of microsoft fabric data pipeline

Hope this helps!
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You