Using PAT (Personal Access Token)

This authentication mechanism uses Personal access token as password and token as UID.

You provide this information to the connector in the connection URL. For more information about the syntax of the connection URL, see Building the Connection URL.

To configure PAT authentication:

  1. Set the AuthMech property to 3.
  2. Set the UID property to token for accessing the Spark server.
  3. Set the PWD property to personal access token.

For example, the following connection URL connects to a Spark server with authentication enabled:

jdbc:databricks://node1.example.com:443;AuthMech=3;UID=token;PWD=simbadatabricksPAT;

In this example, PAT authentication is enabled for JDBC connections, the UID is token, the PWD(personal access token here) is simbadatabricksPAT and the server is listening on port for JDBC connections.