---
title: "databricks-sql-connector | pypx"
description: "Databricks SQL Connector for Python"
canonical_url: "https://pypx.app/packages/databricks-sql-connector"
meta:
  "og:description": "Databricks SQL Connector for Python"
  "og:image": "https://pypx.app/_og/d/h_630%2Cc_PackageCard%2Cname_databricks-sql-connector%2Cversion_4.9.0%2Csummary_Databricks%2BSQL%2BConnector%2Bfor%2BPython%2Clicense_Apache%2BSoftware%2BLicense%2Cp_Ii9wYWNrYWdlcy9kYXRhYnJpY2tzLXNxbC1jb25uZWN0b3Ii%2Cs_JjaOdCsa2uiq_Aip.png"
  "og:image:height": "630"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "databricks-sql-connector 4.9.0"
  "twitter:image": "https://pypx.app/_og/d/h_630%2Cc_PackageCard%2Cname_databricks-sql-connector%2Cversion_4.9.0%2Csummary_Databricks%2BSQL%2BConnector%2Bfor%2BPython%2Clicense_Apache%2BSoftware%2BLicense%2Cp_Ii9wYWNrYWdlcy9kYXRhYnJpY2tzLXNxbC1jb25uZWN0b3Ii%2Cs_JjaOdCsa2uiq_Aip.png"
---

> Index of every page on this site: [llms.txt](https://pypx.app/llms.txt)

# **databricks-sql-connector**

v4.9.0

Databricks SQL Connector for Python

267 KB Python 3.10+ py3-none-anyApache Software License12 deps

[** Diff **](https://pypx.app/packages/databricks-sql-connector/diff)

`$ uv add databricks-sql-connector`

# Databricks SQL Connector for Python

[![PyPI](https://img.shields.io/pypi/v/databricks-sql-connector?style=flat-square)](https://pypi.org/project/databricks-sql-connector/) [![Downloads](https://pepy.tech/badge/databricks-sql-connector)](https://pepy.tech/project/databricks-sql-connector)

The Databricks SQL Connector for Python allows you to develop Python applications that connect to Databricks clusters and SQL warehouses. It is a Thrift-based client with no dependencies on ODBC or JDBC. It conforms to the [Python DB API 2.0 specification](https://www.python.org/dev/peps/pep-0249/).

This connector uses Arrow as the data-exchange format, and supports APIs (e.g. `fetchmany_arrow`) to directly fetch Arrow tables. Arrow tables are wrapped in the `ArrowQueue` class to provide a natural API to get several rows at a time. [PyArrow](https://arrow.apache.org/docs/python/index.html) is required to enable this and use these APIs, you can install it via `pip install pyarrow` or `pip install databricks-sql-connector[pyarrow]`.

The connector includes built-in support for HTTP/HTTPS proxy servers with multiple authentication methods including basic authentication and Kerberos/Negotiate authentication. See `docs/proxy.md` and `examples/proxy_authentication.py` for details.

You are welcome to file an issue here for general use cases. You can also contact Databricks Support [here](https://pypx.app/help.databricks.com).

## Requirements

Python 3.9 or above is required.

## Documentation

For the latest documentation, see

- [Databricks](https://docs.databricks.com/dev-tools/python-sql-connector.html)
- [Azure Databricks](https://docs.microsoft.com/en-us/azure/databricks/dev-tools/python-sql-connector)

For a full reference of every `sql.connect(...)` keyword argument — type, default, per-backend support (Thrift vs Kernel), and meaning — see [`CONNECTION_PARAMETERS.md`](https://pypx.app/CONNECTION_PARAMETERS.md).

## Quickstart

### Installing the core library

Install using `pip install databricks-sql-connector`

### Installing the core library with PyArrow

Install using `pip install databricks-sql-connector[pyarrow]`

### Installing with the Rust kernel backend (`use_kernel=True`)

Install using `pip install databricks-sql-connector[kernel]`

This adds the optional [`databricks-sql-kernel`](https://pypi.org/project/databricks-sql-kernel/) extension (a native Rust client core, exposed via PyO3). Pass `use_kernel=True` to `sql.connect(...)` to route the connection through it instead of the default Thrift backend:

```
connection = sql.connect(
  server_hostname=host,
  http_path=http_path,
  access_token=token,
  use_kernel=True,
)
```

Notes:

- Requires **Python >= 3.10** (the kernel wheel is published as `cp310-abi3`). On older interpreters the `[kernel]` extra installs nothing and `use_kernel=True` raises an `ImportError`.
- The extra also pulls in PyArrow, which the kernel result path requires.
- Authentication supports PAT ( `access_token`), OAuth M2M/U2M, and SP-wide workload identity federation ( `identity_federation_client_id`).

For Lakehouse Real-Time, submit asynchronous statements and poll or fetch results through the submitting connection. Re-fetching and concurrent status polling on that connection are supported. Submitting on one connection and polling or fetching through another connection is unsupported.

```
export DATABRICKS_HOST=********.databricks.com
export DATABRICKS_HTTP_PATH=/sql/1.0/endpoints/****************
```

Example usage:

```
import os
from databricks import sql

host = os.getenv("DATABRICKS_HOST")
http_path = os.getenv("DATABRICKS_HTTP_PATH")

connection = sql.connect(
  server_hostname=host,
  http_path=http_path)

cursor = connection.cursor()
cursor.execute('SELECT :param `p`, * FROM RANGE(10)', {"param": "foo"})
result = cursor.fetchall()
for row in result:
  print(row)

cursor.close()
connection.close()
```

In the above example:

- `server-hostname` is the Databricks instance host name.
- `http-path` is the HTTP Path either to a Databricks SQL endpoint (e.g. /sql/1.0/endpoints/1234567890abcdef), or to a Databricks Runtime interactive cluster (e.g. /sql/protocolv1/o/1234567890123456/1234-123456-slid123)

> Note: This example uses [Databricks OAuth U2M](https://docs.databricks.com/en/dev-tools/auth/oauth-u2m.html) to authenticate the target Databricks user account and needs to open the browser for authentication. So it can only run on the user's machine.

## Transaction Support

The connector supports multi-statement transactions with manual commit/rollback control. Set `connection.autocommit = False` to disable autocommit mode, then use `connection.commit()` and `connection.rollback()` to control transactions.

For detailed documentation, examples, and best practices, see **[TRANSACTIONS.md](https://pypx.app/TRANSACTIONS.md)**.

## SQLAlchemy

Starting from `databricks-sql-connector` version 4.0.0 SQLAlchemy support has been extracted to a new library `databricks-sqlalchemy`.

- Github repository [databricks-sqlalchemy github](https://github.com/databricks/databricks-sqlalchemy)
- PyPI [databricks-sqlalchemy pypi](https://pypi.org/project/databricks-sqlalchemy/)

### Quick SQLAlchemy guide

Users can now choose between using the SQLAlchemy v1 or SQLAlchemy v2 dialects with the connector core

- Install the latest SQLAlchemy v1 using `pip install databricks-sqlalchemy~=1.0`
- Install SQLAlchemy v2 using `pip install databricks-sqlalchemy`

## Contributing

See [CONTRIBUTING.md](https://pypx.app/CONTRIBUTING.md)

## License

[Apache License 2.0](https://pypx.app/LICENSE)

## **Details **

<dl>

<dt>Version</dt>
<dd>4.9.0</dd>

<dt>License</dt>
<dd>Apache Software License</dd>

<dt>Python</dt>
<dd>&lt;4.0,&gt;=3.10</dd>

<dt>Maintainer</dt>
<dd>Databricks</dd>

</dl>

## **Links**

- [Bug Tracker](https://github.com/databricks/databricks-sql-python/issues)
- [Homepage](https://github.com/databricks/databricks-sql-python)
- [View on PyPI](https://pypi.org/project/databricks-sql-connector/)

## **Release Cadence **

**16**

releases in the past year

avg 18 days between releases

## **Maintainers **

- Databricks · [databricks-sql-connector-maintainers@databricks.com](mailto:databricks-sql-connector-maintainers@databricks.com)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://pypx.app/#website","@type":"WebSite","description":"The Python Package Index, reimagined. Fast search, dependency insights, download trends, and changelogs — all in one place.","name":"pypx","url":"https://pypx.app/"},{"@id":"https://pypx.app/packages/databricks-sql-connector#webpage","@type":"WebPage","description":"Databricks SQL Connector for Python","name":"databricks-sql-connector","url":"https://pypx.app/packages/databricks-sql-connector","isPartOf":{"@id":"https://pypx.app/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://pypx.app/packages/databricks-sql-connector"]}]},{"@id":"https://pypx.app/packages/databricks-sql-connector#/schema/software-application/1","@type":"SoftwareApplication","applicationCategory":"DeveloperApplication","description":"Databricks SQL Connector for Python","license":"Apache Software License","name":"databricks-sql-connector","softwareVersion":"4.9.0"}]}
```

## Sitemap

See the full [sitemap](https://pypx.app/sitemap.md) for all pages.
