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.
| Name | Allows you to: |
|---|---|
| SQL connnector to Python | Run SQL commands directly from Python code. This connector is easier to set up than other Python libraries, such as pyODBC. |
| SQLAlchemy | Use Python to interact with Databricks as a SQL data source. SQLAlchemy is a Python SQL toolkit that allows you to work with Python objects instead of writing raw SQL queries. |
| Python and pyODBC | Authenticate and establish a connection from your local Python code to Databricks using ODBC. |
| Databricks SQL Driver for Go | Integrate Go applications with Databricks and use familiar SQL interfaces in the Go programming environment. |
| Databricks SQL Driver for Node.js | Use JavaScript or TypeScript when building applications to query and manipulate data stored in Databricks. |
| Databricks ODBC Driver | Connect participating apps, tools, clients, SDKs, and APIs to Databricks through Open Database Connectivity (ODBC), an industry-standard specification for accessing database management systems. |
| Databricks JDBC drivers (Databricks OSS driver and Simba driver) | Connect participating apps, tools, clients, SDKs, and APIs to Databricks through Java Database Connectivity (JDBC), an industry-standard specification for accessing database management systems. Databricks JDBC Driver (OSS) is the latest version of the driver developed by Databricks. Databricks JDBC Driver (Simba) is an older version of the driver, which is developed by insightsoftware. |
| Databricks SQL Statement Execution API | Run SQL statements to access Databricks data and retrieve results without the need to install database drivers or manage persistent connections. |
| Databricks SQL CLI | Run SQL commands and scripts from the command line. The Databricks SQL CLI connects to Databricks and allows for integration into scripts and automation processes. |
| Databricks Driver for SQLTools for Visual Studio Code | Run SQL queries directly against Databricks from within Visual Studio Code. |
| DataGrip integration with Databricks | Use DataGrip’s integrated development environment (IDE) to connect to Databricks for application development, providing a query console, schema navigation, plan explanation, smart code completion, real-time analysis and quick fixes, refactorings, version control integration, and other features. |
| DBeaver integration with Databricks | Integrate DBeaver, a multi-platform database tool that uses the JDBC protocol, to view and manage data in Databricks. Use the DBeaver SQL editor, data and schema migration tools, and database connection monitoring capabilities. |
| Connect to SQL Workbench/J | Use SQL Workbench/J, a Java-based tool, for connecting to data in Databricks and running SQL scripts without being constrained by operating system limitations. |