Unable to load connections via Databricks CLI Profiles

[CarlaFernandez]

Description

The extension detects but fails to load existing Databricks CLI profiles, even though they are valid and working via the CLI.

---

Environment

• OS: WSL2 – Ubuntu 22.04.5 LTS
• VS Code: 1.101.1
• Databricks Power Tools Extension: 2.8.3
• Databricks CLI: Installed and configured, v0.261.0
• Connection Manager Mode: Databricks CLI Profiles

---

Extension Configuration

Workspace settings:

{
    "databricks.connectionManager": "Databricks CLI Profiles"
}

No additional configuration is defined.

---

Databricks CLI configuration

cat ~/.databrickscfg
[DEFAULT]
host = https://adb-xxxxxxxx.azuredatabricks.net

[adb-279715269194294]
host      = https://adb-xxxxxxx.azuredatabricks.net
auth_type = databricks-cli

My Databricks CLI profiles are valid and functional:

• I can successfully run CLI commands using the configured profiles.
• The profiles are properly defined in the Databricks CLI config file.

---

Observed Behavior

In the VS Code Output panel, I see:

Initializing ConnectionManager CLI ...
Could not load all necessary information from CLI profile 'DEFAULT'!
Could not load all necessary information from CLI profile 'adb-xxxxxxxxxxxx'!
No connections have been configured yet! Please add a connection via the Databricks CLI config file before proceeding!

---

Let me know if any additional logs or diagnostic information would help.

[gbrueckl]

thanks for reporting this - i will have a look and come back to you!

[scott-laj-pfe]

I have the same problem. The extension works if I add "token = ......" to every connection. The documentation does say that token is mandatory, however, I'd prefer to use SSO (OAuth U2M) authentication over tokens.

[gbrueckl]

@scott-laj-pfe to use SSO (OAuth U2M) you might want to install the official Databricks VSCode extension as well and handle authentication there. You can then set the Connection Manager in Databricks Power Tools to Databricks Extension

[gbrueckl]

we might be able to leverage the auth commands of the CLI but this requires a rework of the connection provider.
As of now, only PAT is supported with Databricks CLI Profiles

I will have a look how much effort that would actually be to rework this (and if its working at all)

[gbrueckl]

guess this was easier than expected :D

please check v2.8.6 which i just published to the gallery