{"id":27876,"library":"iomete-sqlalchemy","title":"IOMETE SQLAlchemy Dialect","description":"SQLAlchemy dialect for IOMETE data lakehouse platform using Apache Arrow Flight SQL. Version 1.0.22, monthly releases. Enables connection to IOMETE from Python via SQLAlchemy engine.","status":"active","version":"1.0.22","language":"python","source_language":"en","source_url":"https://github.com/IOMETEOSS/iomete-sqlalchemy","tags":["sqlalchemy","iomete","arrow-flight","data-lakehouse","database"],"install":[{"cmd":"pip install iomete-sqlalchemy","lang":"bash","label":"Default install"}],"dependencies":[{"reason":"Core dependency for SQLAlchemy engine and dialect registration","package":"sqlalchemy","optional":false},{"reason":"Required for Arrow Flight SQL protocol","package":"pyarrow","optional":false},{"reason":"gRPC layer for Arrow Flight","package":"grpcio","optional":false}],"imports":[{"note":"create_engine is from SQLAlchemy, not the dialect package","wrong":"from iomete_sqlalchemy import create_engine","symbol":"create_engine","correct":"from sqlalchemy import create_engine"},{"note":"Use SQLAlchemy's engine type","wrong":"Engine is not exported directly from iomete-sqlalchemy","symbol":"Engine","correct":"from sqlalchemy import Engine"}],"quickstart":{"code":"from sqlalchemy import create_engine\nimport os\n\n# Connection string: iomete://<username>:<password>@<host>:<port>/<database>\nusername = os.environ.get('IOMETE_USERNAME', 'your_username')\npassword = os.environ.get('IOMETE_PASSWORD', 'your_password')\nhost = os.environ.get('IOMETE_HOST', 'your_host')\nport = os.environ.get('IOMETE_PORT', '443')\ndatabase = os.environ.get('IOMETE_DATABASE', 'default')\n\nengine = create_engine(f'iomete://{username}:{password}@{host}:{port}/{database}')\nwith engine.connect() as conn:\n    result = conn.execute(\"SELECT 1\")\n    print(result.fetchone())","lang":"python","description":"Connect to IOMETE using SQLAlchemy engine with IOMETE dialect."},"warnings":[{"fix":"Upgrade Python to 3.9 or later.","message":"Python >=3.9 is required; earlier versions are unsupported.","severity":"breaking","affected_versions":">=1.0.0"},{"fix":"Use urllib.parse.quote for username/password: from urllib.parse import quote; engine_url = f'iomete://{quote(username)}:{quote(password)}@...'","message":"The connection string URL must not contain unsupported special characters in password. Percent-encode if needed.","severity":"gotcha","affected_versions":"all"},{"fix":"Stay updated with changelog; no immediate change required.","message":"The older 'iomete://' dialect prefix might be deprecated in favor of 'iomete+s3' or similar in future versions.","severity":"deprecated","affected_versions":"1.0.x"}],"env_vars":null,"search_vec":"'1.0.22':17 'apach':12 'arrow':13,32 'arrow-flight':31 'connect':21 'data':8,35 'data-lakehous':34 'databas':37 'dialect':3,5 'enabl':20 'engin':28 'flight':14,33 'iomet':1,7,23,30 'lakehous':9,36 'month':18 'platform':10 'python':25 'releas':19 'sql':15 'sqlalchemi':2,4,27,29 'use':11 'version':16 'via':26","created_at":"2026-05-09T05:52:32.882965+00:00","updated_at":"2026-05-09T05:52:32.882965+00:00","problems":[{"fix":"pip install iomete-sqlalchemy. Verify installation: pip list | grep iomete-sqlalchemy","cause":"iomete-sqlalchemy is not installed or entry point not registered.","error":"sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:iomete"},{"fix":"Double-check host:port. Ensure the IOMETE endpoint is reachable (test with telnet or curl).","cause":"Host or port is incorrect, or network/firewall blocks the Flight SQL port.","error":"pyarrow.lib.ArrowIOError: Arrow Flight error: Failed to connect to remote server"}],"ecosystem":"pypi","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":"","cli_version":null,"type":"library","homepage":"https://iomete.com","github":null,"docs":null,"changelog":null,"pypi":"https://pypi.org/project/iomete-sqlalchemy/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["http-networking","database","aws"],"base_url":null,"auth_type":null,"provenance":{"verified_status":"passing","verified_at":"2026-06-29","last_verified":"2026-06-29","next_check":"2026-07-29","install_tag":null}}