Install & Compatibility
Where this runs
No compatibility data collected yet for this library.
Code
Verified usage
Verified import paths — ran on the pinned version, not inferred.
create_engine
✓ from sqlalchemy import create_engine
✗ from iomete_sqlalchemy import create_engine
create_engine is from SQLAlchemy, not the dialect package
Engine
✓ from sqlalchemy import Engine
✗ Engine is not exported directly from iomete-sqlalchemy
Use SQLAlchemy's engine type
Connect to IOMETE using SQLAlchemy engine with IOMETE dialect.
from sqlalchemy import create_engine
import os
# Connection string: iomete://<username>:<password>@<host>:<port>/<database>
username = os.environ.get('IOMETE_USERNAME', 'your_username')
password = os.environ.get('IOMETE_PASSWORD', 'your_password')
host = os.environ.get('IOMETE_HOST', 'your_host')
port = os.environ.get('IOMETE_PORT', '443')
database = os.environ.get('IOMETE_DATABASE', 'default')
engine = create_engine(f'iomete://{username}:{password}@{host}:{port}/{database}')
with engine.connect() as conn:
result = conn.execute("SELECT 1")
print(result.fetchone())
Errors
Common errors & fixes
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:iomete
iomete-sqlalchemy is not installed or entry point not registered.
fixpip install iomete-sqlalchemy. Verify installation: pip list | grep iomete-sqlalchemy
pyarrow.lib.ArrowIOError: Arrow Flight error: Failed to connect to remote server
Host or port is incorrect, or network/firewall blocks the Flight SQL port.
fixDouble-check host:port. Ensure the IOMETE endpoint is reachable (test with telnet or curl).
Upgrade
Version history
1.0.22latest on PyPI · released Apr 7, 2026
Audit
Dependencies
sqlalchemyrequiredCore dependency for SQLAlchemy engine and dialect registration
pyarrowrequiredRequired for Arrow Flight SQL protocol
grpciorequiredgRPC layer for Arrow Flight