-
Notifications
You must be signed in to change notification settings - Fork 2
/
README.Rmd
73 lines (51 loc) · 2.84 KB
/
README.Rmd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
---
always_allow_html: true
output: github_document
---
<!-- README.md is generated from README.Rmd. Please edit that file -->
```{r, include = FALSE}
knitr::opts_chunk$set(
collapse = TRUE,
comment = "#>"
)
```
# README
<!-- badges: start -->
<!-- DOI: All versions. 10.5281/zenodo.4908846 -->
[![DOI](https://img.shields.io/badge/DOI-10.5281%2Fzenodo.4908846 (Latest Version Release)-blue "DOI")](https://doi.org/10.5281/zenodo.4908846)
[![ORCID](https://img.shields.io/badge/ORCID-0000--0002--3600--0972-A6CE39?logo=ORCID&logoColor=A6CE39 "ORCID")](https://orcid.org/0000-0002-3600-0972)
[![Creative Commons CC BY-NC](https://img.shields.io/badge/Creative Commons-BY--NC-EF9421?logo=creative commons&logoColor=EF9421 "CC BY-NC")](https://creativecommons.org/licenses/by-nc-nd/4.0/)
[![Launch Rstudio Binder](http://mybinder.org/badge_logo.svg "Launch RStudio Binder/Container")](https://mybinder.org/v2/gh/libjohn/casestudy_bigquery_dbplyr/master?urlpath=rstudio)
<!-- badges: end -->
_R case study: public datasets in Google BigQuery using DBplyr_
Building on earlier [Rfun](https://rfun.library.duke.edu/) 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](https://rfun.library.duke.edu/portfolio/r_flipped/))
- Use Google [BigQuery public datasets](https://cloud.google.com/bigquery/public-data)
- Install R and RStudio on your computer
- tidyverese, DBI, dbplyr, bigrquery installed in your R environment
```r
install.packages(c("tidyverse", "DBI", "dbplyr", "bigrquery"))
```
## Resources
- [Databases using R](https://db.rstudio.com/)
- [library(DBI)](https://dbi.r-dbi.org/reference/)
- [library(bigrquery)](https://bigrquery.r-dbi.org/)
- [library(dbplyr)](https://dbplyr.tidyverse.org/)
- [RStudio Conf 2019](https://rstudio.com/resources/rstudioconf-2019/databases-using-r-the-latest/) (15 min. video)
### Google Cloud Platform & BigQuery
Get a Google Cloud account
- [BigQuery sandbox](https://cloud.google.com/bigquery/docs/sandbox) **getting started**
- [Google Cloud Platform free tier](https://cloud.google.com/free/docs/gcp-free-tier)
- [BigQuery public datasets](https://cloud.google.com/bigquery/public-data)
- [BigQuery](https://cloud.google.com/bigquery)
- [GCP-BigQuery **Console**](https://console.cloud.google.com/bigquery)
![](images/tree_cover.png)
## 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