You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am using ODBC.load to push updated data into a database. This unfortunately fails if the dataframe contains elements already present in the database.
It would be great is ODBC.load had a "skip existing" option which ignored rows for which the primary key already exists. This would likely require passing the unique column names to the function as well.
This is out of scope for ODBC.load, which appends rows. To insert only new rows, load into a staging table and then run MERGE, or INSERT ... SELECT ... WHERE NOT EXISTS (...), against the target table with DBInterface.execute. Closing as won't-do.
Activity
quinnj-bot commentedon Nov 18, 2026
This is out of scope for
ODBC.load, which appends rows. To insert only new rows, load into a staging table and then runMERGE, orINSERT ... SELECT ... WHERE NOT EXISTS (...), against the target table withDBInterface.execute. Closing as won't-do.[comment generated via AI]