Skip to content

Connect to remote relational databases using dplyr, DBI, and bigrquery packages. Tidyverse/dplyr queries are transformed into SQL database queries. This demo will query Google BigQuery public datasets.

License

Notifications You must be signed in to change notification settings

libjohn/casestudy_bigquery_dbplyr

Repository files navigation

README

DOI

ORCID

Creative Commons CC BY-NC

Launch Rstudio Binder

R case study: public datasets in Google BigQuery using DBplyr

Building on earlier Rfun workshops, exploit your knowledge of familar Tidyverse syntax to query remote databases via RStudio. Attendees will be introduced to the dBplyr package as an alternative to SQL database querying. Following a review of dplyr and an overview of Google BigQuery public datasets, attendees will practice querying Google BigQuery public data.

Prerequisites:

  • Introductory familiarity with R and the Tidyverse (e.g. quickStart with R)
  • Use Google BigQuery public datasets
  • Install R and RStudio on your computer
  • tidyverese, DBI, dbplyr, bigrquery installed in your R environment
install.packages(c("tidyverse", "DBI", "dbplyr", "bigrquery"))

Resources

Google Cloud Platform & BigQuery

Get a Google Cloud account

License

John Little
https://JohnLittle.info
https://Rfun.library.duke.edu
https://library.duke.edu/data

CC BY-NC
Creative Commons Attribution-NonCommercial
https://creativecommons.org/licenses/by-nc/4.0

About

Connect to remote relational databases using dplyr, DBI, and bigrquery packages. Tidyverse/dplyr queries are transformed into SQL database queries. This demo will query Google BigQuery public datasets.

Topics

Resources

License

Stars

Watchers

Forks

Languages