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