Create or overwrite table at connection source

Utility that can be used to sync data against a connection.

db_upsert_table(tbl, df, con = con_bib())

Arguments

tbl

table name

df

data frame or tibble with the data

con

database connection, Default: con_bib()

Value

invisibly TRUE on success

Details

not all backend drivers support overwrite and append, therefore param overwrite for dbWriteTable (see docs) is not used

See also

dbExistsTable,dbRemoveTable,dbWriteTable

Examples

if (FALSE) { # \dontrun{
if(interactive()){
 db_upsert_table("divisions", abm_divisions(), con = con_bib(type = "mssql"))
 }
} # }