When to use Upsert, Append and Overwrite in RDBMS Writer component - Printable Version +- Forums (https://bdn.bdb.ai) +-- Forum: BDB Knowledge Base (https://bdn.bdb.ai/forumdisplay.php?fid=13) +--- Forum: BDB Data Pipeline (https://bdn.bdb.ai/forumdisplay.php?fid=48) +---- Forum: BDB Data Pipeline Q & A (https://bdn.bdb.ai/forumdisplay.php?fid=17) +---- Thread: When to use Upsert, Append and Overwrite in RDBMS Writer component (/showthread.php?tid=495)

When to use Upsert, Append and Overwrite in RDBMS Writer component - gnanashri - 12-23-2022 Overwrite, overwrites the data upon the tables, can be used when you need to change the existing data in the table to the new data  Append, appends on/ adds on to the existing data that is already written in the table.   Upsert, updates and inserts the new data to the previous data in the table.