3 ms·
> allows me to run dplyr operations on database tables Which require that data take a round trip between the R process and the database. It's not uncommon for
by tomnipotent 3y ago
> allows me to run dplyr operations on database tables
Which require that data take a round trip between the R process and the database. It's not uncommon for these jobs to spend more time in the read/write step than doing meaningful work, and why I prefer dbt when possible to keep transformations as close to the data as possible.
- leledavid 3y agoThe dbplyr package takes your R code and executes it in your database, returning a remote dataframe. This is quite useful because there is no mvoving data back and forth.
- nograpes 3y agoThe second point the grandparent made was that they were using dbplyr, which allows you to avoid having the data take a round trip between the R process and the database.