Creating a Managed Service for YDB connection
Written by
Updated at January 18, 2024
Note
To create a connection, you will need a service account with the ydb.viewer or viewer role.
To write subqueries in datasets and queries in QL charts, use YQL syntax
To create a Managed Service for YDB connection:
Warning
If you use a new DataLens object model with workbooks and collections:
- Go to the DataLens home page
. In the left-hand panel, select - Open the workbook, click Create in the top-right corner, and select the appropriate object.
Follow the guide from step 3.
-
Go to the connections page
. -
Click Create connection.
-
Select a YDB connection.
-
Specify the connection parameters:
- 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.
- Database: Select the database to connect or create a new one.
Warning
Capital letters are not allowed in YDB database column names.
- 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.
-
Click Create connection.
-
Enter a name for the connection and click Create.
Note
You can check the host connection before creating it. To do this, click Check connection.