AI engineering glossary · Data engineering
What is upsert?
Upsert (also called Merge): A write that updates a record if its key already exists and inserts it if not, in one operation. It keeps target tables current without duplicates when changed data arrives.
Upsert: an example
An incoming row for customer 501 replaces the old row, while a row for a new customer 9001 is added.
Related terms
More Data engineering terms
Where you learn it
Upsert is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.