Learn R Programming

⚠️There's a newer version (0.5.0) of this package.Take me there.

bigQueryR (version 0.3.2)

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

87

Version

0.3.2

License

MIT + file LICENSE

Maintainer

Mark Edmondson

Last Published

October 23rd, 2017

Functions in bigQueryR (0.3.2)

bq_get_global_project

Get global project name
bq_global_dataset

Set global dataset name
bqr_download_extract

Download extract data
bqr_extract_data

Extract data asynchronously
bigQueryR

bigQueryR
bq_get_global_dataset

Get global dataset name
bq_global_project

Set global project name
bqr_auth

Authenticate this session
bqr_create_table

Create a Table
bqr_delete_table

Delete a Table
bqr_list_projects

List Google Dev Console projects you have access to
bqr_list_tables

List BigQuery tables in a dataset
error.message

Get the error message
format_object_size

taken from utils:::format.object_size
bqr_query_asynch

BigQuery query asynchronously
bqr_table_data

Get BigQuery Table's data list
bqr_wait_for_job

Wait for a bigQuery job
bqr_list_datasets

List BigQuery datasets
bqr_list_jobs

List BigQuery jobs
idempotency

Idempotency
is.NullOb

A helper function that tests whether an object is either NULL _or_ a list of NULLs
myMessage

Customer message log level
parse_bqr_query

Parse table data
bqr_get_job

Poll a jobId
bqr_grant_extract_access

Grant access to an extract on Google Cloud Storage
bqr_table_meta

Get BigQuery Table meta data
rmNullObs

Recursively step down into list, removing all such objects
schema_fields

Create data schema for upload to BigQuery
bqr_upload_data

Upload data to BigQuery
cat0

if argument is NULL, no line output
bqr_partition

Convert date-sharded tables to a single partitioned table
bqr_query

Query a BigQuery Table
is.error

Is this a try error?
js_to_posix

Javascript time to R time
timestamp_to_r

Timestamp to R date