{"library":"sqlalchemy-databricks","title":"SQLAlchemy Dialect for Databricks","type":"library","description":"SQLAlchemy-Databricks is a SQLAlchemy dialect for connecting to Databricks. It enables Python applications to interact with Databricks SQL Endpoints and Unity Catalog using the familiar SQLAlchemy ORM or Core API. The current version is 0.2.0, supporting Python 3.8 and above. The release cadence appears to be infrequent, with two major releases to date.","language":"python","status":"active","last_verified":"Sat May 16","install":{"commands":["pip install sqlalchemy-databricks"],"cli":null},"imports":["from sqlalchemy import create_engine","from sqlalchemy import text"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":null,"github":"https://github.com/crflynn/sqlalchemy-databricks","docs":"https://github.com/crflynn/sqlalchemy-databricks","changelog":null,"pypi":"https://pypi.org/project/sqlalchemy-databricks/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"from sqlalchemy import create_engine, text\nimport os\n\n# Databricks connection details\n# These are typically found in the Databricks SQL Endpoint connection details.\n# server_hostname is like 'dbc-xxxxxxxx-yyyy.cloud.databricks.com'\n# http_path is like '/sql/1.0/endpoints/zzzzzzzzzzzzzzzz'\n# token is a Databricks Personal Access Token or Azure AD Token\n\nDATABRICKS_SERVER_HOSTNAME = os.environ.get('DATABRICKS_SERVER_HOSTNAME', 'your_databricks_hostname')\nDATABRICKS_HTTP_PATH = os.environ.get('DATABRICKS_HTTP_PATH', 'your_http_path')\nDATABRICKS_TOKEN = os.environ.get('DATABRICKS_TOKEN', 'your_databricks_token')\n\n# Construct the connection string\nconnection_string = f\"databricks://token:{DATABRICKS_TOKEN}@{DATABRICKS_SERVER_HOSTNAME}/{DATABRICKS_HTTP_PATH}\"\n\n# Create the engine\ntry:\n    engine = create_engine(connection_string)\n\n    # Establish a connection and execute a simple query\n    with engine.connect() as connection:\n        result = connection.execute(text(\"SELECT 1\")) # Simple test query\n        print(\"Connection successful! Query result:\", result.scalar())\n\n    print(\"\\nSuccessfully connected to Databricks and executed a query.\")\n\nexcept Exception as e:\n    print(f\"Error connecting to Databricks: {e}\")\n    print(\"Please ensure DATABRICKS_SERVER_HOSTNAME, DATABRICKS_HTTP_PATH, and DATABRICKS_TOKEN environment variables are set correctly.\")","lang":"python","description":"This quickstart demonstrates how to establish a connection to a Databricks SQL Endpoint using `sqlalchemy-databricks`. It uses environment variables for sensitive connection details and executes a simple `SELECT 1` query to verify connectivity. Ensure your Databricks SQL Endpoint is running and your token has the necessary permissions.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":{"tag":null,"tag_description":null,"last_tested":"2026-05-16","installed_version":"0.2.0","pypi_latest":"0.2.0","is_stale":false,"summary":{"python_range":"3.10–3.9","success_rate":50,"avg_install_s":15.7,"avg_import_s":0.48,"wheel_type":"sdist"},"results":[{"runtime":"python:3.10-alpine","python_version":"3.10","os_libc":"alpine (musl)","variant":"sqlalchemy-databricks","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"sqlalchemy-databricks","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":14.5,"import_time_s":0.28,"mem_mb":13.4,"disk_size":"354M"},{"runtime":"python:3.11-alpine","python_version":"3.11","os_libc":"alpine (musl)","variant":"sqlalchemy-databricks","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"sqlalchemy-databricks","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":13.6,"import_time_s":0.48,"mem_mb":15.5,"disk_size":"380M"},{"runtime":"python:3.12-alpine","python_version":"3.12","os_libc":"alpine (musl)","variant":"sqlalchemy-databricks","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"sqlalchemy-databricks","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":15.9,"import_time_s":0.7,"mem_mb":15.4,"disk_size":"362M"},{"runtime":"python:3.13-alpine","python_version":"3.13","os_libc":"alpine (musl)","variant":"sqlalchemy-databricks","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.13-slim","python_version":"3.13","os_libc":"slim (glibc)","variant":"sqlalchemy-databricks","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":17.8,"import_time_s":0.64,"mem_mb":15.7,"disk_size":"360M"},{"runtime":"python:3.9-alpine","python_version":"3.9","os_libc":"alpine (musl)","variant":"sqlalchemy-databricks","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.9-slim","python_version":"3.9","os_libc":"slim (glibc)","variant":"sqlalchemy-databricks","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":16.9,"import_time_s":0.32,"mem_mb":12.5,"disk_size":"348M"}]}}