Should `dbAppendTable()` use the `billing=` argument like `dbWriteTable(append=TRUE)` does?

[eheinzen]

I have two BigQuery projects, one ("billing") that I can bill to, but the other ("target") I can't. I establish a database object like this:

conn <- DBI::dbConnect(
  bigrquery::bigquery(),
  project = target,
  dataset = dataset,
  billing = billing
)

The command

DBI::dbAppendTable(conn, "test_table", test_data)

doesn't work, but these both do:

DBI::dbAppendTable(conn, "test_table", test_data, billing = conn@billing)
DBI::dbWriteTable(conn, "test_table", test_data, append = TRUE)

Should dbAppendTable() pass the billing= argument to bq_table_upload() like dbWriteTable() does, too?

dbAppendTable

dbWriteTable passing that argument

[hadley]

Yes.