BQConnection-class: Class "BQConnection"

Description Objects from the Class Extends Methods Examples

Description

Holds auth information to connect to BigQuery.

Objects from the Class

Objects can be created by calls of the form dbConnect(BigQuery(), "username@gmail.com", "password")

Extends

Class "DBIConnection", directly. Class "BQObject", directly. Class "DBIObject", by class "DBIConnection", distance 2. Class "dbObjectId", by class "BQObject", distance 2.

Methods

dbConnect

signature(drv = "BQConnection", username="character", password="character"): ...

dbDisconnect

signature(conn = "BQConnection"): ...

dbGetException

signature(conn = "BQConnection"): ...

dbGetInfo

signature(dbObj = "BQConnection"): ...

dbSendQuery

signature(conn = "BQConnection", statement = "character", verbose="logical", status="logical"): ...

dbGetQuery

signature(conn = "BQConnection", statement = "character"): ...

dbListFields

signature(conn = "BQConnection", name = "character"): ...

dbListResults

signature(conn = "BQConnection"): ...

dbReadTable

signature(conn = "BQConnection", name = "character"): ...

summary

signature(object = "BQConnection"): ...

Examples

1
2
3
4
5
6
 ## Not run: 
    conn <- dbConnect(drv, username="username", password="password")
    result <- dbGetQueyr(conn, "SELECT word FROM [bigquery/samples/shakespeare]
                                WHERE word CONTAINS 'raisin'")

## End(Not run)

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