trino

Connecting Go 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 Go

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 Go program main.go as needed

   • Change the connection arguments in the NewDatabase() call
     • 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 stmt.SetSqlQuery()

3. Run the Go program:

   go mod tidy
   go run main.go

Clean up

1. Stop and remove the Docker container running Trino:

   docker stop trino
   docker rm trino