RBigQuery-package: BigQuery for R

In RBigQuery: BigQuery for R

Description

A DBI extension for querying and parsing results from Google's BigQuery database.

Overview

1. Connect and authenticate with Google:

   conn <- dbConnect(BigQuery(), username="[e-mail]",
                     password="pass")
           

2. Get table fields:

   info <- dbListFields(conn, "bigquery/samples/shakespeare")
           

3. Send a query and if successful get results as data.frame:

   result <- dbSendQuery(conn, "SELECT word FROM 
       [bigquery/samples/shakespeare] WHERE word CONTAINS 'raisin'")
   if (result@success)
       fetch(result)
   else
       dbGetInfo(result, "error")
           

4. Get information about connection, results, etc.:

   summary(BigQuery(), verbose=TRUE)
   summary(conn, verbose=TRUE)
   summary(result, verbose=TRUE)
   dbGetException(conn)
           

Note

This package does not yet support data import or table deletion.

Author(s)

David Xiao <[e-mail]>

See Also

dbDriver dbConnect dbDisconnect dbSendQuery dbGetQuery fetch dbClearResult summary dbGetInfo dbColumnInfo dbGetException dbGetStatement

RBigQuery documentation built on May 2, 2019, 5:09 p.m.