replyr_copy_to: Copy data to remote service.
In WinVector/replyr: Patches to Use 'dplyr' on Remote Data Sources

Description Usage Arguments Value Examples

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
)

`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.

remote handle

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)
}