Share via

ADF to Snowflake sync setup UPSERT

Lina Vaitkiene 0 Reputation points
2026-03-18T10:06:43.4433333+00:00

I Azure Data Factory pipeline setup to sync data into my Snowflake account. Currently I use Snowflake V2 connector, but in my Copy Data action I can't select it to be UPSERT as INSERT duplicates entries which is not correct in my case.

How can I setup UPSERT for my data copy action?

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jorre De Backer 0 Reputation points
    2026-03-18T11:10:26.1266667+00:00

    The Copy Activity doesn't support UPSERT with Snowflake V2 . Can you try swapping it for a Mapping Data Flow, add an Alter Row transformation with upsertIf(true()) and in the Sink settings, enable Allow Upsert, and set your key column. It's a bit more setup but it works well once configured.

    link https://learn.microsoft.com/en-us/azure/data-factory/data-flow-alter-row

    Alter row settings

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.