A upsert operation is an operation against the data that will:
The data upsert operation supports the upsert operation.
- 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:
- and if not present the target primary key.