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

Creating a Trino connection

Written by
Updated at October 11, 2025

To create a Trino connection:

  1. Open the page for creating a new connection.

  2. Under Databases, select the Trino connection.

  3. Select the connection type:

    Select a managed DB in the current Yandex Cloud organization and specify connection parameters for it:

    • Cloud and folder. Select the folder where your service account will be located.
    • Service account. Select an existing service account or create a new one.
    • Cluster. Specify a cluster from the list of available Trino clusters or create a new one.
    • Cache TTL in seconds. Specify the cache time-to-live or leave the default value. The recommended value is 300 seconds (5 minutes).

    • Raw SQL level. Enables you to use an ad-hoc SQL query to generate a dataset. This option is disabled by default. When enabling it, you will need to select the raw SQL level:

      • Allow subqueries in datasets: Describe dataset sources using SQL queries.
      • Allow subqueries in datasets and QL charts: Describe dataset sources using SQL queries and create QL charts.

    image

    Select the authentication mode and manually specify the external database credentials to connect via a public network:

    • Hostname. Specify the Trino coordinator path or IP address.
    • Port. Specify the Trino connection port. The default port is 8443.
    • Username. Specify the username for the Trino connection. (If authentication is disabled, you can use any username as it will not affect the connection. The field value will be sent together with requests to the source.)
    • Cache TTL in seconds. Specify the cache time-to-live or leave the default value. The recommended value is 300 seconds (5 minutes).

    • Raw SQL level. Enables you to use an ad-hoc SQL query to generate a dataset. This option is disabled by default. When enabling it, you will need to select the raw SQL level:

      • Allow subqueries in datasets: Describe dataset sources using SQL queries.
      • Allow subqueries in datasets and QL charts: Describe dataset sources using SQL queries and create QL charts.

    image

    • Hostname. Specify the Trino coordinator path or IP address.
    • Port. Specify the Trino connection port. The default port is 8443.
    • Username. Specify the username for the Trino connection.
    • Password. Enter the password for the specified user.
    • Cache TTL in seconds. Specify the cache time-to-live or leave the default value. The recommended value is 300 seconds (5 minutes).

    • Raw SQL level. Enables you to use an ad-hoc SQL query to generate a dataset. This option is disabled by default. When enabling it, you will need to select the raw SQL level:

      • Allow subqueries in datasets: Describe dataset sources using SQL queries.
      • Allow subqueries in datasets and QL charts: Describe dataset sources using SQL queries and create QL charts.

    image

    • Hostname. Specify the Trino coordinator path or IP address.
    • Port. Specify the Trino connection port. The default port is 8443.
    • Username. Specify the username for the Trino connection.
    • JWT. Specify a JWT.
    • Cache TTL in seconds. Specify the cache time-to-live or leave the default value. The recommended value is 300 seconds (5 minutes).

    • Raw SQL level. Enables you to use an ad-hoc SQL query to generate a dataset. This option is disabled by default. When enabling it, you will need to select the raw SQL level:

      • Allow subqueries in datasets: Describe dataset sources using SQL queries.
      • Allow subqueries in datasets and QL charts: Describe dataset sources using SQL queries and create QL charts.

    image

    Optionally, test the connection. To do this, click Check connection.

  4. Click Create connection.

  5. Select a workbook to save your connection to or create a new one. If using legacy folder navigation, select a folder to save the connection to. Click Create.

  6. Enter a name for the connection and click Create.

Additional settings

You can specify additional connection settings in the Advanced connection settings section:

  • Disable data export: When this option is on, the data export item will be unavailable in the menu of the charts based on this connection. However, you will still be able to copy chart data and take screenshots.

  • Request table list: Disable this option if loading a table list from the source takes too long or produces errors. Instead, use SQL subqueries to add tables.

    image

  • TLS: If this option is enabled, Trino is accessed via HTTPS; if not, HTTP.
  • CA Certificate: To upload a certificate, click Attach file and specify the certificate file. When the certificate is uploaded, the field shows the file name.

  • Disable data export: When this option is on, the data export item will be unavailable in the menu of the charts based on this connection. However, you will still be able to copy chart data and take screenshots.

  • Request table list: Disable this option if loading a table list from the source takes too long or produces errors. Instead, use SQL subqueries to add tables.

image

Connecting an external database

Yandex Cloud holds no responsibility for configuring a remote connection on an external database server side. When connecting an external database which is not a Yandex Cloud resource:

  • When using your own SSL certificate, make sure it matches the one on the database side.

  • Grant database access to the following DataLens IP ranges (/ is followed by subnet mask length):

    • 178.154.242.176/28
    • 178.154.242.192/28
    • 178.154.242.208/28
    • 178.154.242.128/28
    • 178.154.242.144/28
    • 178.154.242.160/28
    • 130.193.60.0/28
    • 2a02:6b8:c03:500:0:f83d:a987:0/112
    • 2a02:6b8:c02:900:0:f83d:a987:0/112
    • 2a02:6b8:c0e:500:0:f83d:a987:0/112
    • 2a02:6b8:c41:1300:0:f83d:a987:0/112
Previous
Creating a Snowflake connection
Next
Creating a connection to files