Bring remote data back as a local data frame tbl.
replyr_copy_from(d, maxrow = 1e+06)
d | remote dplyr data item |
---|---|
maxrow | max rows to allow (stop otherwise, set to NULL to allow any size). |
local tbl.
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') d2 <- replyr_copy_from(d) print(d2) DBI::dbDisconnect(my_db) }#> # A tibble: 2 x 1 #> x #> <dbl> #> 1 1 #> 2 2