Faster Queries and New Capabilities with the Open-Source Databricks JDBC Driver

Summary

The open-source Databricks JDBC driver 3.x and later releases address connectivity needs affecting dashboards, spreadsheets, applications, and other data workflows. Compared with the legacy 2.x driver, they deliver up to 30% faster retrieval of large query results while preserving backward compatibility. Architectural changes add full Arrow-based transfer for JDK 16+, a first-class asynchronous execution API, stream-based ingestion into Databricks Volumes, and integration with the Statement Execution API. The driver also supports stored procedures, multi-statement transactions, Unity Catalog metric views, query tags, geospatial and complex data types, plus built-in client telemetry for query latency, metrics, and errors. Its open-source ownership and Databricks maintenance are presented as enabling faster fixes, new features, transparency, contributions, and tighter platform integration.

Takeaways

1. 1

   The 3.x-and-above driver delivers up to 30% faster large-result retrieval than the legacy 2.x JDBC driver, with backward compatibility maintained during migration.

2. 2

   The driver supports Arrow transfer on JDK 16+, asynchronous query submission, direct Statement Execution API integration, and streaming bulk ingestion into Databricks Volumes without local staging.

3. 3

   New functionality covers stored procedures, multi-statement transactions, Unity Catalog metric views, query tags, geospatial data, complex types, and telemetry for latency, metrics, and errors.