Saving sql queries without collecting it into memory

[hope-data-science]

I have used dplyr and odbc to generate a query, and I do not want to collect it into R memory, instead I want to write it back into the connection. However, the dbWriteTable could not work. Is there any way I can do it?

The question has also been stated in here.

Thanks.

[hope-data-science]

In addition, if db_save_query could work, is there any way to operate data from different connections?

[hadley]

You can use dbplyr::compute to do this: https://dbplyr.tidyverse.org/reference/collapse.tbl_sql.html