BigQuery DBI driver
Creates a BigQuery DBI driver for use in DBI::dbConnect().
## S4 method for signature 'BigQueryDriver'
dbConnect(
drv,
project,
dataset = NULL,
billing = project,
page_size = 10000,
quiet = NA,
use_legacy_sql = FALSE,
bigint = c("integer", "integer64", "numeric", "character"),
...
)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 |
use_legacy_sql |
If |
bigint |
The R type that BigQuery's 64-bit integer types should be mapped to.
The default is |
... |
Other arguments for compatbility with generic; currently ignored. |
if (bq_testable()) {
con <- DBI::dbConnect(
bigquery(),
project = "publicdata",
dataset = "samples",
billing = bq_test_project()
)
con
DBI::dbListTables(con)
DBI::dbReadTable(con, "natality", max_results =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)
}Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.