trino

Connecting Python and Trino with ADBC

Instructions

Tip

If you already have a Trino instance running, skip the steps to run Trino in a Docker container.

Prerequisites

1. Install uv

2. Install dbc

3. Install Docker

Set up Trino

1. Start Trino in a Docker container:

   docker run -d --name trino -p 8080:8080 trinodb/trino

Connect to Trino

1. Install the Trino ADBC driver:

   dbc install trino

2. Customize the Python script main.py as needed

   • Change the connection arguments in db_kwargs
     • Format uri according to the DSN (Data Source Name) format used by the Trino Go client, or keep it as is to use the TPC-H data included in the Trino Docker container image
   • If you changed which Trino instance you're connecting to, also change the SQL SELECT statement in cursor.execute()

3. Run the Python script:

   uv run main.py

Clean up

1. Stop and remove the Docker container running Trino:

   docker stop trino
   docker rm trino