Table of Contents

Search

  1. Preface
  2. Part 1: Hadoop Integration
  3. Part 2: Databricks Integration
  4. Appendix A: Connections Reference

Delta Lake JDBC Connection Properties

Delta Lake JDBC Connection Properties

To enable the domain to access Delta Lake resources in the cloud platform environment, you must manually create and configure a JDBC connection.
Configure the following connection properties:
Property
Description
Name
Type a name for the connection. Example: DatabricksDeltaCxn
ID
Default: Automatically populated with the connection name. Changing this default value is optional.
Username
Type the following value to use the Databricks user token:
token
Password
Value of the token that you configured for the Databricks user.
JDBC Driver Class Name
Type the following value:
com.simba.spark.jdbc4.Driver
Connection String
Connection to the Delta Lake resource. This connection string contains all the information that the domain needs to connect to the resource.
The connection string contains the following elements:
  • jdbc:spark://<server host name>.
  • Port number.
  • Transport mode.
  • ssl. Use
    1
    to enable SSL.
  • httpPath.
  • UID. User ID that will be used to run jobs on the cluster. Use
    token
    .
  • PWD. Value of the token that you configured for the Databricks user.
Example:
jdbc:spark://westus.azuredatabricks.net:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/1654523072521724/0123-456789-films259;AuthMech=3;UID=token;PWD=<token string>
To get the value of these parameters from the Advanced Options area of the cluster configuration settings:
  1. In the Databricks environment, select Clusters.
  2. Select the cluster to connect to.
  3. Expand the Advanced Options and click the
    JDBC/ODBC
    tab.
For more information about the JDBC connection string for Databricks, see the Databricks documentation.

0 COMMENTS

We’d like to hear from you!