Creating a YTsaurus CHYT connection in Yandex DataLens

To create a YTsaurus CHYT connection:

1. Open the new connection creation page.

2. Under Databases, select the YTsaurus CHYT connection.

3. Configure the connection as follows:

   • Host name: Specify the YTsaurus proxy server address.
   • Port: Specify the CHYT connection port.
   • Clique alias: Specify the alias of a running clique. By default, the *ch_public public clique is used.
   • YTsaurus token: Manually set the OAuth token to use with YTsaurus. For more information, see this YTsaurus guide.
   • Cache TTL in seconds: Specify the cache TTL 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 source parameterization: Describe dataset sources using SQL queries and use source parameterization.
     • Allow subqueries in datasets, source parameterization, and QL charts: Describe dataset sources using SQL queries, use source parameterization, and create QL charts.
   • HTTPS. Enable the secure connection option if your server supports HTTPS.

   

4. Optionally, test the connection by clicking Check connection.

5. Click Create connection.

6. 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.

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

Additional settingsAdditional settings

You can limit data export from charts by enabling the Disable data export option under Advanced connection settings. Thus, for charts based on the respective connection, the export data option will not be available in their menu. However, you will still be able to copy chart data and take screenshots.

Use casesUse cases

• Visualizing data from CHYT