Copy data to remote service.

replyr_copy_to(
  dest,
  df,
  name = paste(deparse(substitute(df)), collapse = " "),
  ...,
  rowNumberColumn = NULL,
  temporary = FALSE,
  overwrite = TRUE,
  maxrow = 1e+06
)

Arguments

dest

remote data source

df

local data frame

name

name for new remote table

...

force later values to be bound by name

rowNumberColumn

if not null name to add row numbers to

temporary

logical, if TRUE try to create a temporary table

overwrite

logical, if TRUE try to overwrite

maxrow

max rows to allow in a remote to remote copy.

Value

remote handle

Examples

if (requireNamespace("RSQLite", quietly = TRUE)) { my_db <- DBI::dbConnect(RSQLite::SQLite(), ":memory:") RSQLite::initExtension(my_db) d <- replyr_copy_to(my_db, data.frame(x=c(1,2)), 'd') print(d) DBI::dbDisconnect(my_db) }
#> # Source: table<d> [?? x 1] #> # Database: sqlite 3.30.1 [:memory:] #> x #> <dbl> #> 1 1 #> 2 2