I am using the pool package to connect the database. But when I do `left_join(my_data, by = "id", copy = TRUE), I get the following error.
Error in UseMethod("db_copy_to") :
no applicable method for 'db_copy_to' applied to an object of class "c('Pool', 'R6')"
Note this is not the case with DBI::dbconnect()
.
Details
─ Session info ────────────────────────────────────────────────────────────────
setting value
version R version 4.1.0 (2021-05-18)
os Ubuntu 20.04.2 LTS
system x86_64, linux-gnu
ui RStudio
language (EN)
collate en_ZM.UTF-8
ctype en_ZM.UTF-8
tz Africa/Lusaka
date 2021-07-21