Creates a BigQuery DBI driver for use in DBI::dbConnect()
.
# S4 method for 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) }