-
Download and reference
-
Compute settings
-
Authentication settings
-
Driver capability settings
-
Legacy driver settings
-
Files in Unity Catalog volumes
-
Testing
-
Databricks JDBC Driver (OSS)
-
Databricks SQL Statement Execution API 2.0
-
Databricks Driver for SQLTools for Visual Studio Code
-
Databricks Driver for SQLTools
-
DataGrip
-
DBBeaver
-
SQL Workbench/J
-
Databricks CLI
-
Databricks Asset Bundles
-
Utilities
-
CI/CD
-
Git folders
-
Account and workspace administration
-
Security and compliance
-
Data governance (Unity Catalog)
-
Lakehouse architecture
Reference & resources
-
Reference
-
Resources
-
What’s coming?
-
Documentation archive
Databricks JDBC Driver
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
docs
directory.
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:
-
Compute settings for the Databricks JDBC Driver
-
Authentication settings for the Databricks JDBC Driver
-
Driver capability settings for the Databricks JDBC Driver
-
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
docs
directory.
Additional resources
-
Databricks JDBC Driver Guide
-
DataGrip integration with Databricks
-
DBeaver integration with Databricks
-
Connect to SQL Workbench/J
-
Connect to Infoworks
-
Connect to Qlik Replicate
-
Connect to Stitch
-
Connect to StreamSets
-
Connect to Syncsort
-
Connect to MicroStrategy
