{"repo":"r-dbi/bigrquery","free":true,"listed":false,"github":"https://github.com/r-dbi/bigrquery","clone":"git clone https://github.com/r-dbi/bigrquery.git","description":"An interface to Google's BigQuery from R.","language":"R","stars":528,"topics":["r","database","bigquery"],"license":null,"category":"databases-storage","readme_excerpt":"bigrquery The bigrquery package makes it easy to work with data stored in Google BigQuery by allowing you to query BigQuery tables and retrieve metadata about your projects, datasets, tables, and jobs. The bigrquery package provides three levels of abstraction on top of BigQuery: - The low-level API provides thin wrappers over the underlying REST API. All the low-level functions start with bq , and mostly have the form bq noun verb() . This level of abstraction is most appropriate if you’re familiar with the REST API and you want do something not supported in the higher-level APIs. - The DBI interface wraps the low-level API and makes working with BigQuery like working with any other database system. This is most convenient layer if you want to execute SQL queries in BigQuery or upload smaller amounts (i.e. \\ and create a project. Make a note of the “Project ID” as you’ll use this as the billing project whenever you work with free sample data; and as the project when you work with your own data. Authentication and authorization When using bigrquery interactively, you’ll be prompted to authorize bigrquery in the browser. You’ll be asked if you want to cache tokens for reuse in future sessions. For non-interactive usage, it is preferred to use a service account token, if possible. More places to learn about auth: - Help for bigrquery::bq auth() . - How gargle gets tokens. - bigrquery obtains a token with gargle::token fetch() , which supports a variety of token flows. This arti","default_branch":null,"files":null,"tree":[],"storefront":"/r/r-dbi","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/r-dbi/bigrquery/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}