Yandex Cloud
  • Services
  • Solutions
  • Why Yandex Cloud
  • Blog
  • Pricing
  • Documentation
  • Contact us
Get started
Language / Region
Yandex project
© 2023 Intertech Services AG
Yandex DataLens
  • Getting started
  • Tutorials
    • All tutorials
    • Visualizing data from a CSV file
    • Creating and publishing a chart with a map of Moscow from a CSV file
    • Analyzing a retail chain's sales from a ClickHouse database
    • Analyzing public data on road accidents in Russia
    • Analyzing sales and locations of pizzerias based on data from ClickHouse DB and Marketplace
    • Web analytics with a connection to Yandex Metrica
    • Web analytics with funnels and cohorts calculated based on Yandex Metrica data
    • Mobile app analytics based on AppMetrica data
    • Analyzing Yandex Music podcast statistics (for podcasters)
    • Visualizing data with a QL chart
    • Visualizing data using parameters
    • Visualizing Yandex Monitoring data
    • Building customer journey charts based on AppMetrica data
    • Creating a Bitrix24 connection
  • Concepts
  • Step-by-step guides
  • Access management
  • Pricing policy
  • Visualization reference
  • Function reference
  • Function tutorials
  • Courses
  • Troubleshooting
    • Questions and answers
    • DataLens errors
  1. Tutorials
  2. Visualizing Yandex Monitoring data

Data visualization Yandex Monitoring

Written by
Yandex Cloud
  • Before you begin
  • Create a connection
    • Connecting to Yandex Monitoring
  • Create a QL chart
  • Create a dashboard
  • Add the QL chart to the dashboard
  • Add selectors to the dashboard

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 DataLens homepage.

  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

Note

To create a connection, you need a service account with the monitoring.viewer (or viewer) role.
Use the Yandex Monitoring query language to write queries in QL charts.

Connecting to Yandex Monitoring

To create a Yandex Monitoring connection:

  1. Go to the connections page.

  2. Click Create connection.

  3. Select a Yandex 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.

      metrica-memory-usage

    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 Parameters tab, specify the required time interval.

    monitoring-datetime-parameters

  5. Click Start. 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.

    image

  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.

    image

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

    image

    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.

    image

  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.

    image

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

    image

  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.

    image

See also

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

Was the article helpful?

Language / Region
Yandex project
© 2023 Intertech Services AG
In this article:
  • Before you begin
  • Create a connection
  • Connecting to Yandex Monitoring
  • Create a QL chart
  • Create a dashboard
  • Add the QL chart to the dashboard
  • Add selectors to the dashboard