Issue when connecting to Databricks using OAuth 2.0 token connection string

NetRider
New Contributor

Following the instructions on Authentication settings for the Databricks ODBC Driver | Databricks on AWS I have created both Personal access token and OAuth 2.0 token connection options in an application. However, I realized that, when I use OAuth 2.0 token connection string with specific parameters:

AuthMech=11
Auth_Flow=0
Auth_AccessToken=<oauth-token>

, I am able to successfully connect to Databricks when I put Personal access token as <oauth-token>, which in my case shouldn't be allowed.

On the other hand, if I put OAuth 2.0 token as <personal-access-token> in Personal access token connection string with parameters:

AuthMech=3
UID=token
PWD=<personal-access-token>

, I get an exception, which is a desired behavior.

Is there a way to restrict connecting to Databricks with Personal access token using OAuth 2.0 connection string?

Thank you in advance.

Walter_C
Databricks Employee
Databricks Employee

This will require further analysis, based on the information it seems there is no direct way to restrict this. Are you able to submit a support case so this can be analyzed?