dbConnect() fails with "Invalid DATABRICKS_AUTH_TYPE value 'databricks-cli'"

[dabruehl]

Connecting via DBI::dbConnect() with brickster::DatabricksSQL() fails when the active ~/.databrickscfg profile has auth_type = databricks-cli (the value the Databricks CLI writes automatically after databricks auth login). brickster's auth resolver does not recognize this auth type and errors out instead of falling back to a supported OAuth flow or giving an actionable message.

Reproduce:

library(dplyr)
options(use_databrickscfg = TRUE)
con <- DBI::dbConnect(
  drv = brickster::DatabricksSQL(),
  warehouse_id = "<warehouse_id>"
)

With a .databrickscfg profile generated by use Databricks CLI v1.6.0 containing:

[DEFAULT]
host         = https://<workspace>.azuredatabricks.net
cluster_id   = <cluster_id>
account_id   = <account_id>
workspace_id = <workspace_id>
auth_type    = databricks-cli

[__settings__]
auth_storage    = secure
default_profile = DEFAULT

sessionInfo():

R version 4.5.1 (2025-06-13)
Platform: aarch64-apple-darwin20
Running under: macOS Tahoe 26.5.2

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.5-arm64/Resources/lib/libRlapack.dylib;  LAPACK version 3.12.1

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: Europe/Zurich
tzcode source: internal

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

other attached packages:
[1] dplyr_1.2.1

loaded via a namespace (and not attached):
 [1] vctrs_0.7.3       cli_3.6.6         rlang_1.3.0       otel_0.2.0        DBI_1.3.0        
 [6] purrr_1.2.2       pkgload_1.5.3     generics_0.1.4    glue_1.8.1        dbplyr_2.6.0     
[11] rprojroot_2.1.1   pkgbuild_1.4.8    rappdirs_0.3.4    tibble_3.3.1      ini_0.3.1        
[16] ellipsis_0.3.3    fastmap_1.2.0     lifecycle_1.0.5   httr2_1.2.3       memoise_2.0.1    
[21] compiler_4.5.1    fs_2.1.0          sessioninfo_1.2.4 pkgconfig_2.0.3   rstudioapi_0.19.0
[26] brickster_0.2.13  R6_2.6.1          tidyselect_1.2.1  curl_7.1.0        usethis_3.2.1    
[31] pillar_1.11.1     magrittr_2.0.5    tools_4.5.1       devtools_2.5.2    cachem_1.1.0  

Workaround:
Downgrade to brickster_0.2.12

[zacdav-db]

At currently I'm in two minds about adding proper CLI auth integration, or just falling back to existing flow.

Let me think on this a bit more, the simplest approach is to just ignore databricks-cli and do the existing flow within brickster and have httr2 do all the lifting.

However, supporting databricks-cli is good to have. It just adds a lot more code and likely breaks webR compatibility.

[zacdav-db]

I've created a draft PR to address this issue and properly support CLI auth.

I want to do some manual testing and verification before proceeding, please test #258 if you have time.