iomete-sqlalchemy

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 on this page — 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

iomete-sqlalchemy on PyPI

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

Evidence: iomete_sqlalchemy-1.0.22-py3-none-any.whl

Tags

More Front-Ends packages