R中bigrquery::bq_auth()报invalid_grant Bad Request问题求助

问题现象 #

在全新R会话中本地交互式运行bigrquery::bq_auth()时，未触发浏览器跳转认证，反而抛出以下警告：

Warning message:
Unable to refresh token: invalid_grant
Bad Request

测试环境 #

• 全新安装的R/RStudio与bigrquery包
• 仅执行过以下命令：

  install.packages("tidyverse")
  install.packages("bigrquery")
  bq_auth()
  

初步排查结论 #

• gargle::token_fetch()可正常跳转浏览器完成新认证
• googledrive::drive_auth()也能正常完成认证
• 上述结果说明tidyverse相关API、OAuth机制及令牌逻辑无问题，怀疑问题出在bigrquery的API封装层

R会话信息 #

R version 4.4.1 (2024-06-14)
Platform: aarch64-apple-darwin20
Running under: macOS Sonoma 14.5

Matrix products: default
BLAS:   /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libBLAS.dylib 
LAPACK: /Library/Frameworks/R.framework/Versions/4.4-arm64/Resources/lib/libRlapack.dylib;  LAPACK version 3.12.0

locale:
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8

time zone: America/New_York
tzcode source: internal

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods  
[7] base      

loaded via a namespace (and not attached):
 [1] utf8_1.2.4        R6_2.5.1          bit_4.0.5        
 [4] magrittr_2.0.3    rappdirs_0.3.3    glue_1.7.0       
 [7] tibble_3.2.1      pkgconfig_2.0.3   bit64_4.0.5      
[10] lifecycle_1.0.4   cli_3.6.3         bigrquery_1.5.1  
[13] askpass_1.2.0     fansi_1.0.6       openssl_2.2.0    
[16] gargle_1.5.2      vctrs_0.6.5       DBI_1.2.3        
[19] compiler_4.4.1    httr_1.4.7        rstudioapi_0.16.0
[22] tools_4.4.1       curl_5.2.1        pillar_1.9.0     
[25] rlang_1.1.4       jsonlite_1.8.8    fs_1.6.4         

排查思路建议 #

• 强制清除缓存令牌：运行bigrquery::bq_deauth()，再通过gargle::gargle_cache_dir()获取缓存目录并删除，之后重新执行bq_auth()
• 尝试离线模式认证：调用bq_auth(use_oob = TRUE)，强制触发浏览器跳转完成认证
• 检查账号权限：确认使用的Google账号已启用BigQuery API访问权限，可在Google Cloud控制台中验证API状态
• 升级bigrquery版本：当前使用版本为1.5.1，尝试安装开发版devtools::install_github("r-dbi/bigrquery")后重试
• 开启调试日志：设置options(gargle_verbosity = "debug")后执行bq_auth()，查看详细认证请求日志定位错误环节

内容的提问来源于stack exchange，提问作者Taylor Williams