bigrquery

1.6.2

An Interface to Google's 'BigQuery' 'API'

12packages depend

200.3Kdownloads / year

36.7%test coverage

13/13checks pass

Overview

About

Maintained by Hadley WickhamFirst published 2015-01-1320 releasesCRAN page ↗GitHub ↗

Easily talk to Google's 'BigQuery' database from R.

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("bigrquery", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("r-dbi/bigrquery")

Development version from r-dbi/bigrquery. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-bigrquery

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-bigrquery

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-bigrquery

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

13OK

Slowest check: 2.7 min · r-oldrel-windows-x86_64

Code health

Yes

Tests · ratio 0.47

36.7%

Coverage · measured lines

100%

Documentation · exports

Dependencies · direct

Check history

OK2026-06-09
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-06-08
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-05-02
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-04-25
11 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-04-14
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Show 2 earlier snapshots

ERROR2026-03-16
13 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-03-10
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 545 wordsVignettesNopkgdown siteNoNEWSYes · 100% structuredCode of conductNoContributing guideNo

Examples that run: 75%
Documented parameters: 89%
Return-value docs: 55%
References docs: 0%

Downloads

200.3K

CRAN downloads in the past year

Rank #1,099 · ~549/day · ~16.7K/mo

Releases R versions

Daily download trend is not available in this view yet.

12K30 days

37.7K90 days

200.3K1 year

Compare downloads with other packages →

Also on2.1K r2u80 autocran9.3K conda_forge648 c2d4u

Repository

GitHub ↗ r-dbi/bigrquery

528Stars

191Forks

20Open issues

4Open PRs

20Releases

750Commits

49Contributors

rdatabasebigquery

750 commits · Last activity 2026-05-13 · 0% stars, 30d

Stars over time

2025-05-20 · 5152026-07-07 · 528

Repository practices

Upstream repositoryBeta

12 development-tooling and community-health practices detected across 6 families in the upstream repository

Checks run against github.com/r-dbi/bigrquery on 2026-07-19.

Continuous integration (1)

GitHub Actions

CRAN release process (2)

cran-comments.mdrevdep/

Docs source (1)

README.Rmd

Lint, format, editor (3)

AirVS CodeRStudio project

Show all practices

Coverage (2)

Codecov.covrignore

Governance and community (3)

Issue templatesCODEOWNERSSupport guide

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

28 external dependencies (excludes base and recommended)

Depends (1)

R >= 4.1

Imports (15)

bit64 brio cli clock curl DBI gargle httr jsonlite lifecyclemethodsnanoparquet prettyunits rlang tibble

LinkingTo (3)

cli cpp11 rapidjsonr

Suggests (11)

bigrquerystorage blob covr dbplyr dplyr hms readr sodium testthat withr wk

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

12direct

0indirect

ReviewR allofus basedosdados CDMConnector DatabaseConnector bigrquerystorage cellkeyperturbation dbglm pmparser pointblank sqlhelper tidylearn

Code & Tests

Code Composition

R 7,919 (70%)Rd 1,860 (17%)Markdown 557 (5%)C++ 483 (4%)C 226 (2%)JSON 218 (2%)Other 4 (0%)

Code characteristics

Object systems

S352S4 class3S4 method52

Cyclomatic complexity: 1.0 median / 23 max
Test cases: 146 / 0.47 per code line

Test coverage

Line coverage

37%

Expression

40.9%

Tests / Examples

36.7% / 8% ex

Functions

274 65 exported

Complexity

2.2 avg / 23 max

Call network

274 nodes / 445 edges

Call graph

Open call graph →

Loading call graph…

Lowest coverage

274 functions

Function	Cyclo	Coverage
bq_dataset_create exp	1	0%
bq_dataset_delete exp	1	0%
bq_dataset_exists exp	1	0%
bq_dataset_meta exp	1	0%
bq_dataset_tables exp	1	0%
bq_dataset_update exp	1	0%

People & History

People (3)

Maintainer (1)

Hadley Wickham

Author, Maintainer

Authors (2)

Hadley Wickham

Author, Maintainer

Jennifer Bryan

Author · added in 1.2.0

Posit Software, PBC

Funders (1)

Posit Software, PBC

Listed in earlier versions (3)

RStudio

no longer listed · 0.1.0 to 1.4.1

Kungliga Tekniska Högskolan

no longer listed · 1.0.0 to 1.4.2

The NetBSD Foundation, Inc.

no longer listed · 1.0.0 to 1.4.2

Package Timeline

20 releases. Pick two to compare their code metrics. R releases are shown for context.

1.6.2Latest
2026-05-12 · current release · diff ↗
R
R 4.6.0 released · 2026-04-24
1.6.1
2025-09-10 · diff ↗
1.6.0
2025-09-04 · diff ↗
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
1.5.1
2024-03-14 · diff ↗
1.5.0
2024-01-22 · diff ↗
R
R 4.3.0 released · 2023-04-21
1.4.2
2023-04-20 · diff ↗
1.4.1
2022-10-28 · diff ↗
R
R 4.2.0 released · 2022-04-22
1.4.0
2021-08-05 · diff ↗
R
R 4.1.0 released · 2021-05-18
1.3.2
2020-10-05 · diff ↗
1.3.1
2020-05-15 · diff ↗

Show 17 earlier events

1.3.0
2020-05-08 · diff ↗
R
R 4.0.0 released · 2020-04-24
1.2.0
2019-07-02 · diff ↗
1.1.1
2019-05-16 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.1.0
2019-02-05 · diff ↗
1.0.0
2018-04-24 · diff ↗
R
R 3.5.0 released · 2018-04-23
0.4.1
2017-06-27 · diff ↗
0.4.0
2017-06-23 · diff ↗
R
R 3.4.0 released · 2017-04-21
0.3.0
2016-06-28 · diff ↗
R
R 3.3.0 released · 2016-05-03
0.2.0
2016-03-03 · diff ↗
R
R 3.2.0 released · 2015-04-16
0.1.0
2015-01-13
R
R 3.1.0 released · 2014-04-10

Package metadata

First published: 2015-01-13
Total releases: 20 / 11 yrs
License: MIT + file LICENSE OSI
Minimum R: ≥ 4.1
Download size: 97 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Appears in task views

Databases with R Web Technologies and Services

Report a problem with this page →