Creates a BigQuery DBI driver for use in DBI::dbConnect()
.
Arguments
- drv
an object that inherits from DBIDriver, or an existing DBIConnection object (in order to clone an existing connection).
- project, dataset
Project and dataset identifiers
- billing
Identifier of project to bill.
- page_size
Number of items per page.
- quiet
If
FALSE
, displays progress bar; ifTRUE
is silent; ifNA
displays progress bar only for long-running jobs.- use_legacy_sql
If
TRUE
will use BigQuery's legacy SQL format.- bigint
The R type that BigQuery's 64-bit integer types should be mapped to. The default is
"integer"
which returns R'sinteger
type but results inNA
for values above/below +/- 2147483647."integer64"
returns a bit64::integer64, which allows the full range of 64 bit integers.- ...
Other arguments for compatibility with generic; currently ignored.
Examples
if (bq_testable()) {
con <- DBI::dbConnect(
bigquery(),
project = "publicdata",
dataset = "samples",
billing = bq_test_project()
)
con
DBI::dbListTables(con)
DBI::dbReadTable(con, "natality", n_max = 10)
# Create a temporary dataset to explore
ds <- bq_test_dataset()
con <- DBI::dbConnect(
bigquery(),
project = ds$project,
dataset = ds$dataset
)
DBI::dbWriteTable(con, "mtcars", mtcars)
DBI::dbReadTable(con, "mtcars")[1:6, ]
DBI::dbGetQuery(con, "SELECT count(*) FROM mtcars")
res <- DBI::dbSendQuery(con, "SELECT cyl, mpg FROM mtcars")
dbColumnInfo(res)
dbFetch(res, 10)
dbFetch(res, -1)
DBI::dbHasCompleted(res)
}