Databricks provides a JDBC driver that enables you to connect participating apps, tools, clients, SDKs, and APIs to Databricks through Java Database Connectivity (JDBC), an industry-standard specification for accessing database management systems.
This article and its related articles supplement the information in the Databricks JDBC Driver Guide, available online in PDF format and in your JDBC Driver download’s
Databricks also provides an ODBC Driver. See Databricks ODBC Driver.
The process for using the JDBC driver is as follows:
Download and reference the JDBC driver, depending on your target operating system. See Download and reference the Databricks JDBC Driver.
Gather and store configuration settings for your target Databricks compute resource (a Databricks cluster or a Databricks SQL warehouse), your target Databricks authentication type, and any special or advanced driver capabilities, as a JDBC connection URL or as a programmatic collection of JDBC connection properties. Whether you use a connection URL or a collection of connection properties will depend on the requirements of your target app, tool, client, SDK, or API. See:
To use your connection URL or collection of connection properties with your target app, tool, client, SDK, or API, see Technology partners or your provider’s documentation.
For more information, view the Databricks JDBC Driver Guide in PDF format. This guide is also included as a PDF file named
Databricks JDBC Driver Install and Configuration Guide.pdf in your JDBC driver download’s