[BUG] update_db() doesn't create new table on BigQuery.

[rstats-tips]

Is there an existing issue for this?

• I have searched the existing issues

Have you installed the latest development version of the package(s) in question?

• I have installed the latest development version of the package.

What version of the package do you have?

4.4.0.9012

Describe the bug

Using update_db to create a new table with pbp data in a Google BigQuery database creates the error

Error in `signal_reason()`:
! Not found: Table <PROJECTNAME>:<DATASETNAME>.<TABLENAME> was not found in location EU [notFound] 
Run `rlang::last_error()` to see where the error occurred.

(I've replaced projectname, datasetname and tablename in this output.)

Reprex

library(tidyverse)
library(DBI)
library(nflfastR)


con <- dbConnect(
  bigrquery::bigquery(),
  project = "PROJECTNAME",
  dataset = "DATASETNAME",
  billing = "PROJECTNAME"
)


update_db(
  tblname = "TABLENAME",
  db_connection = con,
)

Expected Behavior

I would expect to get a table called TABLENAME with pbp data

nflverse_sitrep

── System Info ──────────────────────────────────────────────────────────────────────────────────────────────────────────────
• R version 4.2.1 (2022-06-23)   • Running under: macOS Monterey 12.6
── nflverse Packages ────────────────────────────────────────────────────────────────────────────────────────────────────────
• nflreadr (1.3.1.02)    • nflseedR (1.1.0)       • nflplotR (1.1.0.9001)  
• nflfastR (4.4.0.9012)  • nfl4th   (1.0.2.9002)  • nflverse (1.0.2)       
── nflverse Options ─────────────────────────────────────────────────────────────────────────────────────────────────────────
No options set for nflreadr, nflfastR, nflseedR, nfl4th, nflplotR, and nflverse
── nflverse Dependencies ────────────────────────────────────────────────────────────────────────────────────────────────────
• askpass     (1.1)     • gtable      (0.3.1)     • progressr    (0.11.0)   
• bit         (4.0.4)   • hms         (1.1.2)     • proto        (1.0.0)    
• bit64       (4.0.5)   • httr        (1.4.4)     • purrr        (0.3.5)    
• cachem      (1.0.6)   • isoband     (0.2.6)     • R6           (2.5.1)    
• cli         (3.4.1)   • janitor     (2.1.0)     • rappdirs     (0.3.3)    
• clipr       (0.8.0)   • jsonlite    (1.8.2)     • RColorBrewer (1.1-3)    
• codetools   (0.2-18)  • labeling    (0.4.2)     • Rcpp         (1.0.9)    
• colorspace  (2.0-3)   • lattice     (0.20-45)   • readr        (2.1.3)    
• cpp11       (0.4.2)   • lifecycle   (1.0.3)     • rlang        (1.0.6)    
• crayon      (1.5.2)   • listenv     (0.8.0)     • rstudioapi   (0.14)     
• curl        (4.3.3)   • lubridate   (1.8.0)     • scales       (1.2.1)    
• data.table  (1.14.2)  • magick      (2.7.3)     • snakecase    (0.11.0)   
• digest      (0.6.29)  • magrittr    (2.0.3)     • stringi      (1.7.8)    
• dplyr       (1.0.10)  • MASS        (7.3-58.1)  • stringr      (1.4.1)    
• ellipsis    (0.3.2)   • Matrix      (1.5-1)     • sys          (3.4)      
• fansi       (1.0.3)   • memoise     (2.0.1)     • tibble       (3.1.8)    
• farver      (2.1.1)   • mgcv        (1.8-40)    • tidyr        (1.2.1)    
• fastmap     (1.1.0)   • mime        (0.12)      • tidyselect   (1.1.2)    
• fastrmodels (1.0.2)   • munsell     (0.5.0)     • tzdb         (0.3.0)    
• furrr       (0.3.1)   • nlme        (3.1-159)   • utf8         (1.2.2)    
• future      (1.28.0)  • openssl     (2.0.3)     • vctrs        (0.4.2)    
• generics    (0.1.3)   • parallelly  (1.32.1)    • viridisLite  (0.4.1)    
• ggplot2     (3.3.6)   • pillar      (1.8.1)     • vroom        (1.6.0)    
• globals     (0.16.1)  • pkgconfig   (2.0.3)     • withr        (2.5.0)    
• glue        (1.6.2)   • prettyunits (1.1.1)     • xgboost      (1.6.0.1)  
• gsubfn      (0.7)     • progress    (1.2.2)       
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
>

Screenshots

No response

Additional context

Function write_pbp():

When using bigrquery DBI::dbWriteTable() should set parameter append to FALSE when the tables does not yet exist.

[tanho63]

Closing as a bigqueryR DBI spec implementation problem.