remote SQL queries with R
SQL database queries using dplyr; connetcting to databases via DBI
This case study uses library(DBI) and library(bigrquery) to introduce the dBplyr package.
dbplyr enables Tidyverse users to leverage
dplyr functions, rather than composing SQL queries because basic
dplyr verbs are transformed into SQL. Additionaly, the DBI package is used to broker database connections (such as ODBC.)
install.packages(c("tidyverse", "DBI", "dbplyr", "bigrquery"))