Data Operation - Upsert | Op | Tabulify - Growing data proficiency of the world

Data Operation - Upsert


A upsert operation is an operation against the data that will:

  • try to insert a record
  • and update it if it already exists.

The data upsert operation supports the upsert operation.


What happens when multiple target unique constraint matches the source columns

A upsert does an update when a unique constraint is violated after insertion. This is not possible to specify two unique constraints and therefore Tabulify needs to choose one.

If you have multiple target unique constraints matched by the source columns, the process takes as unique constraint:

  • the first target unique key found in the source columns.
  • and if not present the target primary key.
Powered by ComboStrap