bigrquery
An interface to Google's BigQuery from R.
The bigrquery package provides R interfaces for working with Google BigQuery, allowing you to query tables and manage BigQuery resources like projects, datasets, and jobs. It offers three levels of interaction: low-level REST API wrappers, a DBI interface for standard database operations, and a dplyr interface for working with BigQuery tables like in-memory data frames.
The package solves the problem of choosing the right abstraction level for your workflow. The low-level API gives you full control for advanced use cases, the DBI interface lets you write SQL queries and upload data under 100 MB like any other database, and the dplyr interface automatically generates SQL from R code so you don’t need to write queries manually. This flexibility makes it suitable whether you’re familiar with BigQuery’s REST API or prefer working with standard R database tools.
