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.