Cross-posted: https://stackoverflow.com/questions/61851640/creating-table-in-big-query-using-dbi-returns-type-not-found-float-error
I'm trying to create mtcars
table in Big Query as it is described in a documentation:
con <- DBI::dbConnect(
bigrquery::bigquery(),
project = project,
dataset = dataset,
billing = billing
)
DBI::dbWriteTable(con, "mtcars", mtcars)
However, I get an error:
Running job '...
Error: Job '...' failed
x Type not found: FLOAT at [2:9] [invalidQuery]
Run `rlang::last_error()` to see where the error occurred.
In addition: Warning message:
In class(obj) <- c("scalar", class(obj)) :
Setting class(x) to multiple strings ("scalar", "SQL", ...); result will no longer be an S4 object
What am I doing wrong?