Databricks Connection Help
RazorSQL provides the ability to automatically download and install the Databricks JDBC driver for connecting to Databricks databases. JDBC is the recommended way to connect to Databricks in RazorSQL. RazorSQL also supports connecting to Databricks via ODBC on Windows machines.
Connecting to Databricks via JDBC
To connect to a Databricks database, select Databricks as the database type on the window that appears after selecting the Connections -> Add Connection Profile menu option. Select the JDBC (Databricks) connection type from the connection type list. This will display the window where users can enter their Databricks specific connection details.
Click the "Auto Download Driver" button to have RazorSQL download and install the Databricks JDBC driver. Then, under the Authentication section, select whether the user will be authenticating to Databricks via a User Login and Password or via an Access Token. Below is information on the rest of the fields required for the Databricks connection.
Login: This is the login / user id for the database. This is generally
an email address. If using Access Token authentication, this field is not needed.
Password: This is the password for the databricks database.
Access Token: If authenticating via something like a Personal Access Token,
enter the access token in this field. If using the access token type of authentication,
the login and password is not required.
Host or IP Address: This is the host name of IP address of the Databricks database.
If using the Databricks Community Edition, this will generally be the following: community.cloud.databricks.com
Port: This is the HTTP port the database is listening on. Generally this would be 443
Database Name: This is the name of the database to set as the default database for the connection.
Use SSL Encryption: Check this to use SSL encryption on the connection. Generally this should be checked.
HTTP Path: This is required for the connection. If using the Databricks Community Edition,
the HTTP Path can be found by going to the Cluster or Compute resource, and on the Configuration tab,
click on the JDBC / ODBC sub-tab. This will section will display the host, port, and HTTP Path information.
Connecting to Databricks via ODBC
To connect to Databricks via ODBC, the Databricks ODBC driver must be downloaded and installed.
Next, an ODBC data source must be set up via the Windows data sources control panel. See the
following link for more information:
ODBC Setup
Manual Databricks JDBC Information
If manually configuring your connection, use the following
for the JDBC driver class and JDBC URL format:
Driver Class: com.databricks.client.jdbc.Driver
JDBC URL Format:
jdbc:databricks://<host>:<port>[/<database_name>];transportMode=http;ssl=1;httpPath=<httpPath>;AuthMech=3;
