Databricks Connection Help

RazorSQL includes the ability to auto-install the Databricks JDBC driver. Once the driver is downloaded and installed after clicking the Auto-install Driver button, a connection to Databricks can be established.

Listed below is information on the fields needed to create a Databricks connection:

Authentication Type

The Databricks driver supports authentication either via a user name and password, or via a token such as a personal access token. To authentication via a user name and password, select the User and Password button. To authentication via a token, select the Access Token button.

Login: If using the User and Password authentication type, enter the user name / login id in this field.

Password: Enter the password for the database here.

Access Token: If authenticating via a token such as a personal access token, enter the token value here.

Host or IP Address: The host or ip address of the Databricks server. For example, if using the Databricks community edition, the value may be community.cloud.databricks.com

Port: The port for the database. When using Databricks with SSL enabled, this would typically be 443.

Database Name: If a value is specified for the database name, after connecting, RazorSQL will set that value as the default database.

Use SSL Encryption: If checked, the connection to Databricks will be done over https. If not checked, http will be used.

Http Path: This value is required for the connection and can be retrieved from the JDBC/ODBC section for the Cluster or Compute details. For example, for the Databricks community edition, this value would typically start with something like sql/protocolv1/

Max Rows to Return: The maximum number of rows to return per query. Once the max number is reached, RazorSQL will not fetch any more rows from the MongoDB database.