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"))


GitHub Code Repository Creative Commons CCBY-NC Launch RstudioBinder

Rfun is a DVS learning series

The 'R We Having Fun Yet?' learning series is part of the broader Data & Visualization Services workshop series. DVS offers workshops on [R], Python, GIS and mapping, Research Data Management, and Visualization.

Rfun Blog

The blog features semester summaries of our workshop series and extra bits of information which may assist you in your practical data science journeys.