bigrquery: An Interface to Google's BigQuery API

R上でGoogleのBigQueryを扱う

> library(bigrquery)

バージョン: 0.3.0.9000

関数名	概略
`DBI`	DBI methods
`bigrquery`	An R interface to google's bigquery.
`copy_table`	Copy one or more source tables to a destination table.
`dbi_driver`	BigQuery DBI driver
`delete_dataset`	Deletes an existing dataset in a project
`delete_table`	Delete a table.
`format_dataset`	Format dataset and project ID as a BQ-style identifier
`format_table Format dataset, project and table ID as a`	BQ-style identifier
`get_dataset`	Gets an existing dataset in a project
`get_job`	Check status of a job.
`get_table`	Retrieve table metadata
`insert_dataset`	Creates a new dataset in a project
`insert_query_job`	Create a new query job.
`insert_upload_job`	Upload data.
`list_datasets`	List the datasets in a project
`list_projects`	List projects that you have access to
`list_tabledata`	Retrieve data from a table.
`list_tables`	List available tables in dataset.
`parse_dataset`	Parse a BQ-style identifier into project/dataset IDs
`parse_table`	Parse a BQ-style identifier into project/dataset/table IDs
`query_exec`	Run a asynchronous query and retrieve results.
`src_bigquery`	A bigquery data source.
`update_dataset`	Updates an existing dataset in a project
`wait_for`	Wait for a job to complete, optionally printing updates

get_table

> get_table("publicdata", "samples", "github_timeline")

query_exec

クエリーを実行する

> query_exec(query, 
+            project, 
+            destination_table = NULL, 
+            default_dataset = NULL,
+            page_size = 10000, 
+            max_pages = 10, 
+            warn = TRUE)