Skip to content

Trino guide

The Trino ADBC driver is distributed via the ADBC Driver Foundry, not PyPI. Follow the Foundry installation guide to install it before using TrinoConfig.

adbc-poolhouse does not need a separate extra for Trino:

pip install adbc-poolhouse

Connection

TrinoConfig supports URI-based or individual field connection specification.

URI

from adbc_poolhouse import TrinoConfig, create_pool

config = TrinoConfig(
    uri="trino://me:s3cret@trino.example.com:8443/my_catalog/my_schema",  # pragma: allowlist secret
)
pool = create_pool(config)

Individual fields

config = TrinoConfig(
    host="trino.example.com",
    port=8443,
    user="me",
    password="s3cret",  # pragma: allowlist secret
    catalog="my_catalog",
)
pool = create_pool(config)

Loading from environment variables

TrinoConfig reads all fields from environment variables with the TRINO_ prefix:

export TRINO_HOST=trino.example.com
export TRINO_USER=me
export TRINO_PASSWORD=s3cret  # pragma: allowlist secret
export TRINO_CATALOG=my_catalog

config = TrinoConfig()  # reads from env

See also