---
id: sqlalchemy-databricks
version: "0.2.0"
license: MIT
license_treatment: permissive
maintenance: abandoned
---

# sqlalchemy-databricks — SQLAlchemy Dialect for Databricks

License: permissive · Maintenance: abandoned · Downloads: 469.2K/mo

## What it is and what it does

sqlalchemy-databricks is a SQLAlchemy dialect that registers the `databricks+connector` driver, allowing you to use SQLAlchemy's ORM and query tools against Databricks clusters. It wraps the official databricks-sql-connector to provide standard SQLAlchemy connection and table introspection APIs.

The package is designed for developers who want to query Databricks using SQLAlchemy's familiar syntax rather than raw SQL. It supports both workspace and SQL analytics clusters through a standard connection URL pattern. However, the project is archived and has received no updates since 2022-05-06, meaning it may not work with recent versions of its dependencies or Databricks platform changes.

Use it for:

- Building Python applications that query Databricks tables using SQLAlchemy ORM without writing raw SQL.
- Migrating existing SQLAlchemy code from other databases to Databricks with minimal refactoring.
- Automating table discovery and metadata inspection on Databricks clusters via SQLAlchemy's reflection API.
- Prototyping data pipelines that read from Databricks using standard SQLAlchemy patterns.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Provides a SQLAlchemy dialect that connects to Databricks workspaces and SQL analytics clusters using the official databricks-sql-connector driver.

No. The package is abandoned (last update 2022-05-06, archived repository) and has not been maintained since its initial release window. While it has low install friction and permissive MIT licensing, the lack of maintenance creates a high risk of incompatibility with current Databricks and SQLAlchemy versions. For new projects, prefer the official databricks-sql-connector directly or check whether Databricks or the SQLAlchemy community now provide a maintained dialect.

## Install

pip install sqlalchemy-databricks
uv add sqlalchemy-databricks
poetry add sqlalchemy-databricks

## Installing sqlalchemy-databricks

Before you install: Installation is straightforward with low friction. However, the package is archived and abandoned as of 2023-05-15, with no maintenance activity since its last release on 2022-05-06. Relying on it for new projects carries significant risk of incompatibility with future Databricks or SQLAlchemy releases.

License in practice: MIT license is permissive and places no restrictions on use, modification, or distribution in commercial or private projects.

Quickstart:

pip install sqlalchemy-databricks

from sqlalchemy import create_engine
engine = create_engine(
    "databricks+connector://token:<token>@<host>:443/<database>",
    connect_args={"http_path": "<cluster_path>"}
)

Requires a Databricks account with a valid token and cluster HTTP path; databricks-sql-connector and SQLAlchemy must be installed as runtime dependencies.

Verify before relying:

- Compatibility with current Databricks SQL connector and SQLAlchemy versions given the package's abandoned status.
- Whether the dialect works reliably with Python 3.10 despite no recent maintenance.
- Current viability for production use given the archived repository status.

## Package facts

- License: MIT (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: abandoned
- Downloads: 469.2K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy databricks dialect, databricks sql connector, orm for databricks, databricks database adapter, sqlalchemy databricks integration, abandoned, databricks, sqlalchemy-dialect

[View on SkillFed](https://skillfed.io/packages/sqlalchemy-databricks) · [View on PyPI](https://pypi.org/project/sqlalchemy-databricks/)