DBEAVER Connection to Sql Warehouse in Databricks

[ADBQueries]

I'm trying to connect to SQL warehouse in Azure Datebricks with DBEAVER application.

I'm creating a jdbc connection string as mentioned here: https://docs.databricks.com/en/integrations/jdbc/authentication.html

Here is a sample connection link I have created: 

JDBC Connection String:
jdbc:databricks://adb-3XXXXXXXXXXXXXX.XX.azuredatabricks.net:443;httpPath=/sql/1.0/warehouses/XXXXXXXXXXXXXXXX;AuthMech=3;UID=token;PWD=<PATTokenCreatedFromMyAccountOnDatabricks>

Here is a generic error that I'm Getting:
[Databricks][JDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 403, Error message: Unknown.
  HTTP Response code: 403, Error message: Unknown
  HTTP Response code: 403, Error message: Unknown

[Kaniz_Fatma]

Hi @ADBQueries, 

• Ensure that you’re using the correct authentication mechanism. In your JDBC connection string, you’ve specified AuthMech=3, which corresponds to token-based authentication.
• Double-check that the token you’re using is valid and has the necessary permissions to access the Databricks resources.
• Consider removing the UID and PWD parameters from the connection string. Instead, rely solely on the token in the URL for authentication.
• Verify that you have the appropriate permissions on the Databricks workspace resource in Azure. You should have either a Contributor or Owner role.
• Navigate to the Azure Portal > Azure Databricks > Azure Databricks Service > Access control (IAM) an...
• Check if your workspace has an IP Access List configured. Ensure that traffic is routed correctly via VPN or the correct HTTP proxy.
• Consult your Databricks administrator to verify the IP access settings
• If you’re accessing Databricks endpoints using just the access token (as in CI/CD workflows), add the service principal as a user in the Databricks workspace.
• In this case, only the access token is required for authentication³.

[Ayushi_Suthar]

Hi @ADBQueries , Good Day! 

Could you please try running the code again to generate another access token and, once generated, check it on this page, https://jwt.ms, to confirm that the token has not expired?

Also, if not done yet, please review the following discussions on this same error/issue:

https://stackoverflow.com/questions/76426385/databricksdatabricksjdbcdriver500593-communication-link...

Please let me know if this helps and leave a like if this information is useful, followups are appreciated.
Kudos
Ayushi