Learn R Programming

bigQueryR (version 0.5.0)

Interface with Google BigQuery with Shiny Compatibility

Description

Interface with 'Google BigQuery', see for more information. This package uses 'googleAuthR' so is compatible with similar packages, including 'Google Cloud Storage' () for result extracts.

Copy Link

Version

Install

install.packages('bigQueryR')

Monthly Downloads

136

Version

0.5.0

License

MIT + file LICENSE

Maintainer

Mark Edmondson

Last Published

October 9th, 2019

Functions in bigQueryR (0.5.0)

bqr_create_table

Create a Table
bqr_list_datasets

List BigQuery datasets
bqr_list_projects

List Google Dev Console projects you have access to
bqr_get_global_dataset

Get global dataset name
bqr_global_project

Set global project name
bqr_get_job

Poll a jobId
bqr_get_global_project

Get global project name
bqr_global_dataset

Set global dataset name
bqr_list_jobs

List BigQuery jobs
bqr_list_tables

List BigQuery tables in a dataset
bqr_grant_extract_access

Grant access to an extract on Google Cloud Storage
bqr_partition

Convert date-sharded tables to a single partitioned table
bqr_table_meta

Get BigQuery Table meta data
bqr_table_data

Get BigQuery Table's data list
bqr_query

Query a BigQuery Table
bqr_query_asynch

BigQuery query asynchronously
schema_fields

Create data schema for upload to BigQuery
parse_bqr_query

Parse table data
bqr_wait_for_job

Wait for a bigQuery job
bqr_upload_data

Upload data to BigQuery
bqr_patch_table

Update a Table
Table

Table Object
bqr_copy_table

Copy BigQuery table
bigQueryR

bigQueryR
bqr_auth

Authenticate this session
bqr_delete_table

Delete a Table
bqr_download_extract

Download extract data
bqr_copy_dataset

Copy datasets
bqr_extract_data

Extract data asynchronously
bqr_download_query

Download data from BigQuery to local folder