---
id: iomete-sqlalchemy
version: "1.0.22"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# iomete-sqlalchemy — SQLAlchemy dialect for IOMETE via Arrow Flight SQL

License: permissive · Maintenance: active · Downloads: 196.5K/mo

## What it is and what it does

iomete-sqlalchemy is a SQLAlchemy dialect that bridges SQLAlchemy's ORM and Core APIs to IOMETE data warehouses by routing queries through Arrow Flight SQL via the adbc-driver-flightsql transport. It implements all reflection methods—schema inspection, table listing, column discovery—and gracefully handles relational metadata (primary keys, foreign keys, indexes) by returning empty results rather than raising errors, making it compatible with schema inspection tools and data catalog integrations.

The dialect handles connection management through a standard SQLAlchemy URL format, supporting gRPC transport configuration (TLS, message size limits), catalog/schema navigation, and type mapping between Spark/Iceberg types and SQLAlchemy's type system. It is actively maintained and requires Python 3.9+, SQLAlchemy 2.0.30 or later, and the Arrow Flight SQL driver stack.

Use it for:

- Connect a Python ORM or query builder to IOMETE for interactive analytics and reporting
- Integrate IOMETE schema metadata into data catalogs or lineage tools via SQLAlchemy reflection
- Execute parameterized SQL queries on IOMETE clusters from Python applications without raw gRPC calls
- Build ETL pipelines that read from or write to IOMETE using SQLAlchemy's declarative models
- Enable BI tools and query engines that support SQLAlchemy dialects to query IOMETE warehouses

## Worth the install?

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

Provides a SQLAlchemy dialect for connecting to IOMETE data warehouses via Arrow Flight SQL, enabling standard SQLAlchemy operations and schema reflection on IOMETE clusters.

Yes, if you need to query IOMETE from Python via SQLAlchemy. The package is actively maintained, has low install friction, carries a permissive license, and implements full schema reflection. It is a straightforward fit for projects already using SQLAlchemy that need IOMETE connectivity. No known vulnerabilities as of the fact sheet date.

## Install

pip install iomete-sqlalchemy
uv add iomete-sqlalchemy
poetry add iomete-sqlalchemy

## Installing iomete-sqlalchemy

Before you install: Low friction install with a pure-Python wheel. Maintenance status is active. Requires SQLAlchemy 2.0.30 or later, adbc-driver-flightsql 1.1.0+, and pyarrow 16.0+, all of which are standard data-stack dependencies.

License in practice: Licensed under Apache-2.0 (permissive), allowing use in commercial and open-source projects with minimal restrictions beyond attribution and liability disclaimers.

Quickstart:

pip install iomete-sqlalchemy

from sqlalchemy import create_engine, text

engine = create_engine(
    "iomete://username:password@host:443/catalog/schema"
    "?cluster=my-cluster&data_plane=my-plane"
)
with engine.connect() as conn:
    result = conn.execute(text("SELECT 1")).scalar()

Requires Python 3.9+, SQLAlchemy >= 2.0.30, adbc-driver-flightsql >= 1.1.0, and pyarrow >= 16.0. Needs valid IOMETE host, credentials, cluster, and data plane configuration.

Verify before relying:

- Whether reflection methods fully support all IOMETE schema metadata beyond graceful empty results for PK/FK/indexes
- Performance characteristics and query optimization for large result sets over Arrow Flight
- Compatibility with specific IOMETE versions beyond the stated driver requirements

## Package facts

- License: Apache-2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 196.5K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy dialect iomete, arrow flight sql connector, iomete database driver, sqlalchemy iomete integration, data warehouse sql interface, flight sql adapter, iomete schema reflection, sqlalchemy-dialect, arrow-flight, data-warehouse

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