Contact UsGet started
© 2025 Direct Cursus Technology L.L.C.

Connecting to a Trino cluster

Written by
Updated at November 24, 2025

This section presents settings for connection to the Managed Service for Trino cluster using command line tools, from graphical IDEs and WebSQL. To learn how to connect from your application code, see Connection string examples.

Note

If the connection requires a port, use port 443.

Command line tools

Trino CLI

If you do not have the Trino CLI yet, install it using the guide on the official Trino website.

To connect to an Managed Service for Trino cluster:

  1. Create an IAM token and put it to the TRINO_PASSWORD environment variable:

    export TRINO_PASSWORD=$(yc iam create-token)

    This IAM token in TRINO_PASSWORD will be your password to the Managed Service for Trino cluster. To enable it, specify the --password flag upon connection.

  2. Connect to the Managed Service for Trino cluster:

    ./trino c-<cluster_ID>.trino.yandexcloud.net --user iam --password

    You can get the cluster ID with the list of clusters in the folder.

Connecting from graphical IDEs

Before connecting:

  1. Create an IAM token:

    yc iam create-token

  2. Save the token. You will use it as a password for the connection.

  1. Create a data source:
    1. Select File → New → Data Source → Trino.
    2. Enter a name for the data source.
    3. Specify the connection settings on the General tab:
      • Host: c-<cluster_ID>.trino.yandexcloud.net.
      • Port: 443.
      • User: iam.
      • Password: Previously created IAM token.
  2. Click Test Connection. If the connection is successful, you will see the connection status, DBMS information, and driver details.
  3. Click OK to save the data source.
  1. Create a new database connection:
    1. In the Database menu, select New connection.
    2. Select Trino from the list.
    3. Click Next.
    4. Specify the connection settings on the Main tab:
      • Host: c-<cluster_ID>.trino.yandexcloud.net.
      • Port: 443.
      • Under Authentication, specify:
        • Username: iam.
        • Password: Previously created IAM token.
  2. Click Test Connection .... If the connection is successful, you will see the connection status, DBMS information, and driver details.
  3. Click Done to save the database connection settings.

WebSQL

  1. In the management console, open Managed Service for Trino.

  2. Open your Managed Service for Trino cluster.

  3. Navigate to WebSQL.

  4. Click Go to WebSQL.

  5. In the SQL query editor that opens, run the following query:

    SELECT version() AS version;

    The response will contain Trino version information.

Examples of connection strings

Python

Before connecting:

  1. Install the dependencies:

    pip3 install trino

  2. Create an IAM token and put it to the TOKEN environment variable:

    export TOKEN=$(yc iam create-token)

  1. Code example:

    connect.py

    import os
from contextlib import closing
from trino.dbapi import connect
from trino.auth import BasicAuthentication

TIMEOUT = 10
COORDINATOR_URL = 'c-<cluster_ID>.trino.yandexcloud.net'
IAM_TOKEN = os.environ['TOKEN']

def get_version():
    auth = BasicAuthentication(username='iam', password=IAM_TOKEN)
    with closing(connect(host=COORDINATOR_URL, port=443, auth=auth, request_timeout=TIMEOUT)) as conn:
        with closing(conn.cursor()) as cur:
            cur.execute('SELECT version() as version')
            rows = cur.fetchall()
            print(rows[0])

if __name__ == "__main__":
    get_version()

    You can request the cluster ID with the list of clusters in the folder.

  2. Connecting:

    python3 connect.py

Java

Before connecting:

  1. Install the dependencies:

    sudo apt update && sudo apt install --yes openjdk-21-jre maven

  2. Create a directory for the Maven project:

    cd ~/ && mkdir -p project/src/main/java/com/example && cd project/

  3. Create a configuration file for Maven:

    pom.xml
    <?xml version="1.0" encoding="utf-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>
    <groupId>com.example</groupId>
    <artifactId>app</artifactId>
    <version>0.1.0</version>
    <packaging>jar</packaging>
    <properties>
        <maven.compiler.source>21</maven.compiler.source>
        <maven.compiler.target>21</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>
    <dependencies>
        <dependency>
            <groupId>io.trino</groupId>
            <artifactId>trino-jdbc</artifactId>
            <version>469</version>
        </dependency>
    </dependencies>
    <build>
        <finalName>${project.artifactId}-${project.version}</finalName>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-assembly-plugin</artifactId>
                <version>3.7.1</version>
                <executions>
                    <execution>
                        <goals>
                            <goal>single</goal>
                        </goals>
                        <phase>package</phase>
                        <configuration>
                            <descriptorRefs>
                                <descriptorRef>
                                    jar-with-dependencies</descriptorRef>
                            </descriptorRefs>
                            <archive>
                                <manifest>
                                    <mainClass>com.example.App</mainClass>
                                </manifest>
                            </archive>
                        </configuration>
                    </execution>
                </executions>
            </plugin>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-jar-plugin</artifactId>
                <version>3.4.2</version>
                <configuration>
                    <archive>
                        <manifest>
                            <mainClass>com.example.App</mainClass>
                        </manifest>
                    </archive>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

  4. Create an IAM token and put it to the TOKEN environment variable:

    export TOKEN=$(yc iam create-token)

  1. Code example:

    src/main/java/com/example/App.java

    package com.example;

import java.sql.DriverManager;
import java.util.Properties;

public class App {
    private static final String COORDINATOR_URL = "c-<cluster_ID>.trino.yandexcloud.net";

    public static void main(String[] args) {
        String url = String.format("jdbc:trino://%s", COORDINATOR_URL);
        String iamToken = System.getenv("TOKEN");
  
        Properties properties = new Properties();
        properties.setProperty("user", "iam");
        properties.setProperty("password", iamToken);
        properties.setProperty("SSL", "true");

        try (var connection = DriverManager.getConnection(url, properties)) {
            var rs = connection.createStatement().executeQuery("SELECT version() as VERSION");
            if (rs.next()) {
                System.out.println(rs.getString(1));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

    You can request the cluster ID with the list of clusters in the folder.

  2. Building and connecting:

    mvn clean package && \
java -jar target/app-0.1.0-jar-with-dependencies.jar

Node.js

Before connecting:

  1. Install the dependencies:

    sudo apt update && sudo apt install --yes nodejs npm && \
npm install trino-client

  2. Create an IAM token and put it to the TOKEN environment variable:

    export TOKEN=$(yc iam create-token)

app.mjs

"use strict";
import {BasicAuth, Trino} from 'trino-client';

const COORDINATOR_URL = 'c-<cluster_ID>.trino.yandexcloud.net'
let TOKEN = process.env.TOKEN

async function get_version() {
    const trino = Trino.create({server: COORDINATOR_URL,auth: new BasicAuth('iam', TOKEN)});
    const query = await trino.query('SELECT version() as VERSION');
    const queryResult = await query.next()
    console.log(queryResult.value.data[0][0])
}

get_version();

You can request the cluster ID with the list of clusters in the folder.

Connecting:

node app.mjs
Previous
Stopping and starting a cluster
Next
Maintenance