In Databricks, AuthMech=3 is a parameter used when configuring JDBC or ODBC drivers to connect to your Databricks workspace. It indicates that you want to use a specific authentication mechanism, typically involving a personal access token, username, password, or combination.

JDBC Driver

For the Databricks JDBC driver, you would set the AuthMech property to 3 in your connection string, along with other properties like UID (for your username or token) and PWD (for your password or token).

Example:

String url = “jdbc:data bricks://<server-hostname>:443”;

Properties p = new java.util.Properties();

p.put(“httpPath”, “<http-path>”);

p.put(“AuthMech”, “3”);

p.put(“UID”, “<username-or-token>”);

p.put(“PWD”, “<password-or-token>”);

Connection conn = DriverManager.getConnection(URL, p);

ODBC Driver

For the Databricks ODBC driver, you would typically set AuthMech=3 along with the UID and PWD parameters in your DSN (Data Source Name) configuration or a DSN-less connection string.

Example (DSN-less connection string):

Driver=<path-to-driver>;

Host=<server-hostname>;

Port=443;

HTTPPath=<http-path>;

AuthMech=3;

UID=<username-or-token>;

PWD=<password-or-token>;

Important Considerations:

• Personal Access Tokens: If using a personal access token, you would typically set UID to “token” and PWD to your actual token value.
• Username and Password: If you use a username and password, ensure that single sign-on (SSO) is disabled for your Databricks workspace.