Data visualization Yandex Monitoring

The scenario will be useful to those users who have already deployed and launched one of the Yandex Cloud services.

You will create a chart based on the Yandex Monitoring query language and place it on the dashboard.

To visualize and explore data, set up DataLens and follow the steps below:

1. Create a connection.
2. Create a QL chart.
3. Create a dashboard.
4. Add the QL chart to the dashboard.
5. Add selectors to the dashboard.

Before you begin

To get started with DataLens:

1. Log in to your Yandex account.

2. Open the homepage DataLens.

3. Click Open DataLens.

4. Select one of the options:

   • If you already have an organization, select it from the drop-down menu in the Organizations tab and click Open DataLens.

     Note

     To activate a DataLens instance, the user must have the admin or owner role. For more information about roles, see Granting permissions in Organization.

   • If you have a cloud but no organization, click Add new DataLens. In the window that opens, enter your organization's name and description and click Create organization and DataLens. For more information about working with organizations, see Getting started with organizations.

   If you have a technical question about the service, please contact Yandex Cloud support. To ask for advice, discuss the solution to your problem or best practices of the service, write to the DataLens chat in Telegram.

Create a connection

Connecting to Yandex Monitoring

To create a Yandex Monitoring connection:

1. Go to the connections page.

2. Click Create connection.

3. Select a Monitoring connection.

4. Specify the connection parameters:

   • Cloud and folder. Select the folder where your service account is located.
   • Service account. Select an existing service account or create a new one.

5. Click Create connection.

6. Enter the connection name and click Create. The connection appears in the list.

Create a QL chart

1. Go to the created connection.

2. In the top right-hand corner, click Create QL chart.

3. On the Query tab, enter the query code. You can either write it or copy it from Yandex Monitoring.

   How to copy a query from Yandex Monitoring

   1. Go to the desired dashboard in Yandex Monitoring. For dashboard availability, you must be running one of the Yandex Cloud services.

   2. To open the desired chart in Metric Explorer, click in the upper-right corner of the chart.

      

   3. At the bottom of the screen, go to the Queries tab.

   4. In the line with the desired query, click and select Copy as text.

      Example query:

      alias(series_max("systag", trunc("mem.*"{service="managed-clickhouse", host="rc1a-jn5r2zlul3iydlo2.mdb.yandexcloud.net", resource_id="Test", resource_type="cluster", node="*", systag!="-"})), "{{systag}}")
      

4. On the Params tab, specify the required time interval.

   

5. Click Run. Check that the query is executed without errors and the chart with the data is displayed.

6. In the upper right-hand corner, click Save.

7. Enter the chart name Monitoring Data Chart and click Save.

You can place the chart created on the dashboard. You can also add a selector to the dashboard to control the QL chart interval parameter.

Create a dashboard

Create a dashboard to add these charts to.

1. Go to the DataLens homepage.

2. Click Create dashboard.

   

3. Enter the dashboard name Monitoring Data and click Create.

   The dashboard created will open for editing.

Add the QL chart to the dashboard

1. At the top of the page, click Add and select Chart.

   

2. In the Chart field, click Select and select the previously created Monitoring Data Chart chart from the chart list.

   

   Click Add.

3. The chart is displayed on the dashboard. Stretch it to improve visualization.

4. Save the dashboard.

Add selectors to the dashboard

Add a selector to select the time interval for which the data is displayed:

1. At the top of the page, click Add.

2. Choose Selector.

   

3. Select Manual input as source type.

4. Under Field or parameter name, enter interval. Certain selector values will be passed into this query variable.

5. Choose Calendar as your selector type.

6. Enable Range.

   

7. In the Default value field, specify the values in offsets from the current date and click Apply.

   

8. Enable the Title option and enter Date interval.

9. Click Add.

10. Place the selector on the dashboard under the chart.

11. Save the dashboard.

12. Your dashboard is ready. You can now select the time interval using the selector.

    

See also

• Adding charts to dashboards
• Adding selectors to dashboards
• Creating a QL chart
• QL chart