UPSERT and INSERT Feature in Data Loader


Two conditional loading options that give you precise control over how records are written to your target table.

UPSERT

This feature updates the row in the target table if a matching row exists; otherwise, if the matching row does not exist, it inserts a new row.

Below is an example showing the source and target table, and the result you get when you choose the UPSERT loading option, comparing on the column ORDER_ID.

UPSERT example in Data Loader

INSERT

This feature inserts a row into the target table only if a matching row does not already exist.

Below is an example showing the source and target table, and the result you get when you choose the INSERT loading option, comparing on the column ORDER_ID.

INSERT example in Data Loader — conditionally insert rows in target table