Simba JDBC Driver (Legacy)

Note

This page applies to the Simba JDBC Driver (Legacy), versions below version 3. Databricks strongly recommends migrating to the Databricks JDBC Driver for JDBC connectivity. It includes improvements such as support for Unity Catalog metric views, transactions that span multiple SQL statements, stored procedures, faster large-result retrieval, and built-in client telemetry.

Databricks JDBC, the first version of the driver, is a Simba driver developed by insightsoftware. Use it to connect apps, tools, clients, SDKs, and APIs to Azure Databricks through Java Database Connectivity (JDBC), an industry-standard specification for accessing database management systems.

This section supplements the information in the Databricks JDBC Driver Guide (HTML or PDF). The PDF is also included in your driver download's docs directory.

Note

Azure Databricks also provides an ODBC driver. See Databricks ODBC Driver.

Process overview

The process for using the JDBC driver includes the following steps:

  1. Download and reference the JDBC driver, depending on your target operating system. See Download and reference the Databricks JDBC Driver (Simba).
  2. Configure connection settings for authentication, compute resources (cluster or SQL warehouse), and driver capabilities. Set these as a connection URL or connection properties based on your tool's requirements. See:
  3. 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.

Next steps

  • Last updated on