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