SQL connectors, libraries, drivers, APIs, and tools

Databricks has SQL connectors, libraries, drivers, APIs, and tools that allow you to connect to Databricks, interact programmatically, and integrate Databricks SQL functionality into applications written in popular languages such as Python, Go, JavaScript and TypeScript.

For recommendations for when to use connectors or drivers, see Local development tools.

Database connectivity

• • Databricks JDBC Driver
  • Connect Java applications and tools to Databricks using the native JDBC driver developed by Databricks.
• • Databricks JDBC Driver (Simba)
  • Legacy JDBC driver developed by insightsoftware. Use the Databricks JDBC Driver for new projects.
• • Databricks ODBC Driver (Simba)
  • Connect applications and tools to Databricks using the industry-standard Open Database Connectivity (ODBC) protocol.

Python libraries and connectors

• • SQL connnector for Python
  • Run SQL commands directly from Python code with simple setup and minimal dependencies.
• • SQLAlchemy
  • Connect Python applications to Databricks using object-relational mapping instead of writing raw SQL queries.
• • pyODBC
  • Connect Python applications to Databricks using the ODBC protocol for standard database connectivity.

Other language drivers

• • SQL Driver for Go
  • Connect Go applications to Databricks using familiar SQL database interfaces.
• • SQL Driver for Node.js
  • Connect JavaScript and TypeScript applications to Databricks for data querying and manipulation.

APIs and command line tools

• • SQL Statement Execution API
  • Run SQL statements and retrieve results using a REST API without installing drivers or managing connections.
• • SQL CLI
  • Run SQL commands and scripts from the command line for integration with automation workflows.

IDE and database tools

• • Driver for SQLTools
  • Run SQL queries directly against Databricks from within Visual Studio Code.
• • DataGrip
  • Connect to Databricks using DataGrip's database IDE for SQL development with intelligent code completion, schema navigation, and query analysis.
• • DBeaver
  • Connect to Databricks using DBeaver's multi-platform database tool for SQL editing, schema management, and data migration.
• • SQL Workbench/J
  • Connect to Databricks using SQL Workbench/J, a cross-platform Java-based tool for running SQL scripts and managing database connections.