About

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.

Requirements

• The source data resource should be in a tabular format and have data for all constrained columns of the target table.
• The target data resource should have a unique column.

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.