Creating a connection to Trino in Yandex DataLens

To create a Trino connection:

1. Open the connection creation page.

2. Under Databases, select the Trino connection.

3. Select the connection type:

   Select in organization

   Specify manually

   1. Select a managed database in the current Yandex Cloud organization and specify the 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 the cluster from the list of available Trino clusters or create a new one.

      • 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:

        • Subqueries only: Describe dataset sources using SQL queries.
        • SQL to read: Describe dataset sources using SQL queries, create QL charts, and execute read-only SQL queries.

   2. Optionally, specify the caching settings:

      • Cache TTL: Specify cache TTL in seconds or leave the default value. The recommended value is 300 seconds (5 minutes).
      • Allow cache verification in datasets: Specify the maximum cache validation interval in seconds.

   3. Optionally, configure Advanced connection settings. For more information, see Additional settings.

   1. Select the Authentication type:

      • Without authentication
      • Password
      • JWT

   2. Specify the external database credentials for connection over a public network:

      • Host name: Specify the Trino coordinator path or IP address.
      • Port: Specify the Trino connection port. The default port is 8443.
      • Username: Specify a username for the Trino connection. If authentication is off, you can use any username as it will not affect the connection. The field value will be sent to the source with the queries.
      • Password: If the Password authentication type was selected, specify the password for the user.
      • JWT: If the JWT authentication type was selected, specify the JWT.

      • 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:

        • Subqueries only: Describe dataset sources using SQL queries.
        • SQL to read: Describe dataset sources using SQL queries, create QL charts, and execute read-only SQL queries.

   3. Optionally, specify the caching settings:

      • Cache TTL: Specify cache TTL in seconds or leave the default value. The recommended value is 300 seconds (5 minutes).
      • Allow cache verification in datasets: Specify the maximum cache validation interval in seconds.

   4. Optionally, configure Advanced connection settings. For more information, see Additional settings.

   5. Optionally, test the connection by clicking 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.

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

Additional settingsAdditional settings

You can specify additional connection settings under Advanced connection settings:

Connecting an external databaseConnecting an external database

Yandex Cloud holds no responsibility for configuring a remote connection on an external database server side. When connecting an external database that 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 the subnet mask length):

  ipv4

  ipv6

  • 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

Creating a datasetCreating a dataset

The table search scope when connecting to Trino is limited to a specific folder.

When creating a dataset based on the Trino connection:

1. In the top-right corner of the connection page, click Create dataset.

2. Select the folder in the source. The tables it contains will be shown on the panel below.

   Selecting a folder in the source

   

3. Proceed with this guide from Step 4.