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.)
Library packages
install.packages(c("tidyverse", "DBI", "dbplyr", "bigrquery"))
Resources
