R Observatory: Metrics for bigrquery version 1.6.2

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

bigrquery

1.6.2Package record

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

3packages dependsuggested by 9

179.7Kdownloads / year

36.7%test coverage

13/13flavors OK

Overview

About

Maintained by Hadley WickhamCRAN page ↗GitHub ↗Website ↗Issues ↗Declared funder: Posit Software, PBC

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

Changes in 1.6.2

BigQuery error messages containing { or } are no longer mistaken for cli expressions, so the underlying server message is shown instead of a cli parse failure (#677).
bq_dataset_query(), bq_project_query(), bq_table_copy(), bq_table_download(), bq_table_load(), bq_table_save(), and bq_table_upload() now respect getOption("bigrquery.quiet") as the default for quiet (@r2evans, #663).
bq_perform_query() and friends gain a labels argument that attaches BigQuery labels to the resulting job, useful for cost allocation. dbConnect() gains a matching labels argument that is forwarded to every job run on the connection. Defaults to getOption("bigrquery.labels") (@JulianUmbhau, #673).
bq_perform_upload() and friends now default to 22 digits of accuracy, and allow you to change this value with the new json_digits argument. They now also upload POSIXt objects with 6 digits (i.e. microsecond) precision (#660), and correctly set the "tzone" attribute of uploaded POSIXt columns to Sys.timezone() when the timezone is empty or not defined (@r2evans, #660).
dbAppendTable() now correctly uses the billing project from the connection (@eheinzen, #638).
dbCreateTable() and dbWriteTable() now correctly say that temporary = TRUE (rather than FALSE) is unsupported (#670).
dbExecute() gains params= support (@r2evans, #667).
dbExecute() and dbSendQuery() error if you accidentally use parameters (@r2evans, #667).
tbl() no longer errors when given a literal SQL query that contains three or more periods (#611).

From NEWS.md in the release

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. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

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). We list this channel from recorded autoCRAN download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

Health

CRAN checks

13OK

CRAN check page ↗

Slowest check: 3.4 min · r-devel-windows-x86_64

Status changes

OK13 OK2026-08-05
NOTE12 OK, 1 NOTE2026-08-01
OK13 OK2026-06-09
ERROR12 OK, 1 ERROR2026-06-08
OK13 OK2026-05-02

Show 4 earlier changesHide 4 earlier changes

NOTE11 OK, 1 NOTE2026-04-25
OK14 OK2026-04-14
ERROR13 OK, 1 ERROR2026-03-16
OK14 OK2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 1.6.2

READMEYes · 545 wordsVignettesNoNEWSYes · 100% structured · mentions 1.6.2Citation fileNoWebsiteYes · pkgdown

Help pages: 23 (5 internal)includes a package overview page
Examples that run: 75%15 run in a plain check (10 of them under a condition) · 5 never run
Exported functions with examples: 100%
Documented parameters: 89%
Return-value docs: 55%
Help pages citing references: 0%

How these are measured

Downloads

179.7K

CRAN downloads in the past year

Rank #1,063 · ~492/day · ~15K/mo

Releases R versions

Daily download trend is not available in this view yet.

12.2K30 days

35.9K90 days

179.7K1 year

Compare downloads with other packages →

Also on3.3K r2u59 autocran9.5K conda_forge679 c2d4u

How downloads are counted

Repository

r-dbi/bigrquery ↗Organization: r-dbi

531Stars

190Forks

24Open issues

5Open PRs

20Releases

750Commits

49Commit identities

rdatabasebigquery

750 commits · Last activity 2026-05-13 · +0.2% stars, 30d · Default branch at 1.6.2.9000, ahead of CRAN 1.6.2 (checked 2026-10-11)

Responsiveness

How these are sampled

PRs merged (all time): 70%
Median days to close, 50 most recently updated closed issues: 41
Median days to close, 50 most recently updated closed PRs: 0

Stars over time

2025-10-13 · 5192026-10-08 · 531

How these are measured

PracticesBeta

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

Checks run against github.com/r-dbi/bigrquery on 2026-10-11.

Continuous integration (2)

GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux, macOS and Windows, and on R-devel

Governance and community (5)

Code of conductContributing guideIssue templatesCODEOWNERSSupport guide

Docs source (4)

README.Rmdpkgdown

GitHub Pages site last deployed 2026-05-13 · The repository has a site deploy workflow

pkgdown site last built 2026-05-13

Coverage (2)

Coverage reporting (Codecov).covrignore

Show all practicesHide 2 practices

CRAN release process (2)

cran-comments.mdrevdep/

Lint, format, editor (4)

Lint workflowAirVS CodeRStudio project

How this is detected·Detection ruleset v3 (2026-09-26)

AI coding toolsBeta

This repository shows signs of AI coding tools.

Claude Codefirst seen 2026-01-16
Seen in the repository: .claude, .claude/skills
Named in .Rbuildignore: .claude

From outside contributors

Claude Code
Pull requests: 2 from outside contributors, first on 2025-07-13, 2 from forks

How this is detected·Detection ruleset v4 (updated 2026-09-27)

Dependencies

Declared dependencies

28 external dependencies (excludes base and recommended)

Installing bigrquery adds 32 packages (21 with compiled code, 13 MB of source tarballs). Heaviest: fs 1.4 MB, nanoparquet 1.1 MB, openssl 1.1 MB.

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

3direct

0indirect

Imports 3

Suggested by 9

Depends, Imports or LinkingTo, most downloaded first

basedosdados allofus ReviewR

Suggests, most downloaded first

DatabaseConnector CDMConnector pointblank bigrquerystorage pmparser tidylearn sqlhelper dbglm cellkeyperturbation

How these are counted

Code & Tests

People & History

People (3)

Hadley Wickham

Author, Maintainer since 0.1.0 (2015)

Jennifer Bryan

Author · added in 1.2.0

Posit Software, PBC

Copyright holder, Funder · added in 1.4.2

Listed in earlier versions (3)

Show 3 peopleHide 3 people

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

Releases (20)

Pick two releases to compare their code metrics.

1.6.2Latest
record
2026-05-12 · current release · diff ↗
R
R 4.6.0 released · 2026-04-24
1.6.1
record
2025-09-10 · diff ↗
1.6.0
record
2025-09-04 · diff ↗ ·
removed 1 export
bq_oauth_app

added 1 export
bq_perform_query_schema
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
1.5.1
record
2024-03-14 · diff ↗
1.5.0
record
2024-01-22 · diff ↗ ·
removed 31 exports
delete_dataset, delete_table, exists_dataset, exists_table, format_dataset, format_table, get_access_cred, get_dataset, get_job, get_table, has_access_cred, insert_dataset, insert_extract_job, insert_query_job, insert_table, insert_upload_job, list_datasets, list_projects, list_tabledata, list_tabledata_callback, list_tabledata_iter, list_tables, parse_dataset, parse_table, query_exec, reset_access_cred, set_access_cred, set_oauth2.0_cred, set_service_token, update_dataset and 1 more
R
R 4.3.0 released · 2023-04-21
1.4.2
record
2023-04-20 · diff ↗ ·
added 1 export
bq_oauth_client
1.4.1
record
2022-10-28 · diff ↗
R
R 4.2.0 released · 2022-04-22
1.4.0
record
2021-08-05 · diff ↗
R
R 4.1.0 released · 2021-05-18
1.3.2
record
2020-10-05 · diff ↗ ·
added 1 export
bq_perform_query_dry_run
1.3.1
record
2020-05-15 · diff ↗

Show 17 earlier eventsHide 17 earlier events

1.3.0
record
2020-05-08 · diff ↗ ·
added 3 exports
bq_param, bq_param_array, bq_param_scalar
R
R 4.0.0 released · 2020-04-24
1.2.0
record
2019-07-02 · diff ↗ ·
added 8 exports
bq_auth, bq_auth_configure, bq_deauth, bq_has_token, bq_oauth_app, bq_table_patch, bq_token, bq_user
1.1.1
record
2019-05-16 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.1.0
record
2019-02-05 · diff ↗
1.0.0
record
2018-04-24 · diff ↗ ·
removed 1 export
copy_table

added 50 exports
as_bq_dataset, as_bq_field, as_bq_fields, as_bq_job, as_bq_table, bq_authable, bq_dataset, bq_dataset_create, bq_dataset_delete, bq_dataset_exists, bq_dataset_meta, bq_dataset_query, bq_dataset_tables, bq_dataset_update, bq_field, bq_fields, bq_job, bq_job_meta, bq_job_show_statistics, bq_job_status, bq_job_wait, bq_perform_copy, bq_perform_extract, bq_perform_load, bq_perform_query, bq_perform_upload, bq_project_datasets, bq_project_jobs, bq_project_query, bq_projects and 20 more
R
R 3.5.0 released · 2018-04-23
0.4.1
record
2017-06-27 · diff ↗
0.4.0
record
2017-06-23 · diff ↗ ·
added 5 exports
bigquery, exists_dataset, insert_extract_job, insert_table, set_oauth2.0_cred
R
R 3.4.0 released · 2017-04-21
0.3.0
record
2016-06-28 · diff ↗ ·
added 2 exports
dbi_driver, set_service_token
R
R 3.3.0 released · 2016-05-03
0.2.0
record
2016-03-03 · diff ↗ ·
added 9 exports
copy_table, delete_dataset, exists_table, format_dataset, format_table, get_dataset, insert_dataset, list_tabledata_iter, update_dataset
R
R 3.2.0 released · 2015-04-16
0.1.0
record
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 · relicensed from GPL-3 in 1.5.0
Minimum R: ≥ 4.1
Download size: 100 KB

Appears in task views

Databases with R Web Technologies and Services

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("bigrquery")

Format

Wickham, H., Posit Software, PBC, & Bryan, J. (2026). bigrquery: An Interface to Google's 'BigQuery' 'API' (Version 1.6.2) [Computer software]. https://doi.org/10.32614/CRAN.package.bigrquery

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for bigrquery version 1.6.2 [Data set]. HJJB, LLC. Data release v2026-10-18. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-18, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →