Yandex Cloud
Search
Contact UsGet started
  • Blog
  • Pricing
  • Documentation
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • ML & AI
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Customer Stories
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Education and Science
    • Yandex Cloud Partner program
  • Blog
  • Pricing
  • Documentation
© 2025 Direct Cursus Technology L.L.C.
Yandex Object Storage
    • All tutorials
    • Getting statistics on object queries with S3 Select
    • Getting website traffic statistics with S3 Select
    • Getting statistics on object queries using Yandex Query
    • Generating a resource-by-resource cost breakdown report using S3 Select
    • Server-side encryption
    • Integrating an L7 load balancer with CDN and Object Storage
    • Blue-green and canary deployment of service versions
    • Analyzing logs in DataLens
    • Mounting buckets to the file system of Yandex Data Processing hosts
    • Using Object Storage in Yandex Data Processing
    • Importing data from Object Storage, processing and exporting to Managed Service for ClickHouse®
    • Mounting a bucket as a disk in Windows
    • Migrating data from Yandex Data Streams using Yandex Data Transfer
    • Using hybrid storage in Yandex Managed Service for ClickHouse®
    • Loading data from Yandex Managed Service for OpenSearch to Yandex Object Storage using Yandex Data Transfer
    • Automatically copying objects from one bucket to another
    • Recognizing audio files in a bucket on a regular basis
    • Training a model in Yandex DataSphere on data from Object Storage
    • Connecting to Object Storage from VPC
    • Migrating data to Yandex Managed Service for PostgreSQL using Yandex Data Transfer
    • Uploading data to Yandex Managed Service for Greenplum® using Yandex Data Transfer
    • Uploading data to Yandex Managed Service for ClickHouse® using Yandex Data Transfer
    • Uploading data to Yandex Managed Service for YDB using Yandex Data Transfer
    • Exchanging data between Yandex Managed Service for ClickHouse® and Yandex Data Processing
    • Uploading data from Yandex Managed Service for YDB using Yandex Data Transfer
    • Hosting a static Gatsby website in Object Storage
    • Migrating a database from Managed Service for PostgreSQL to Object Storage
    • Exchanging data between Yandex Managed Service for ClickHouse® and Yandex Data Processing
    • Importing data from Yandex Managed Service for PostgreSQL to Yandex Data Processing using Sqoop
    • Importing data from Yandex Managed Service for MySQL® to Yandex Data Processing using Sqoop
    • Migrating data from Yandex Object Storage to Yandex Managed Service for MySQL® using Yandex Data Transfer
    • Migrating a database from Yandex Managed Service for MySQL® to Yandex Object Storage
    • Exporting Greenplum® data to a cold storage in Yandex Object Storage
    • Loading data from Yandex Direct to a Yandex Managed Service for ClickHouse® data mart using Yandex Cloud Functions, Yandex Object Storage, and Yandex Data Transfer
    • Migrating data from Elasticsearch to Yandex Managed Service for OpenSearch
    • Uploading Terraform states to Object Storage
    • Locking Terraform states using Managed Service for YDB
    • Visualizing Yandex Query data
    • Publishing game updates
    • VM backups using Hystax Acura
    • Backing up to Object Storage with CloudBerry Desktop Backup
    • Backing up to Object Storage with Duplicati
    • Backing up to Object Storage with Bacula
    • Backing up to Yandex Object Storage with Veeam Backup
    • Backing up to Object Storage with Veritas Backup Exec
    • Managed Service for Kubernetes cluster backups in Object Storage
    • Developing a custom integration in API Gateway
    • URL shortener
    • Storing application runtime logs
    • Developing a skill for Alice and a website with authorization
    • Creating an interactive serverless application using WebSocket
    • Deploying a web application using the Java Servlet API
    • Developing a Telegram bot
    • Replicating logs to Object Storage using Fluent Bit
    • Replicating logs to Object Storage using Data Streams
    • Uploading audit logs to ArcSight SIEM
    • Exporting audit logs to SIEM Splunk systems
    • Creating an MLFlow server for logging experiments and artifacts
    • Operations with data using Yandex Query
    • Federated data queries using Query
    • Recognizing text in image archives using Vision OCR
    • Converting a video to a GIF in Python
    • Automating tasks using Managed Service for Apache Airflow™
    • Processing files with usage details in Yandex Cloud Billing
    • Deploying a web app with JWT authorization in API Gateway and authentication in Firebase
    • Searching for Yandex Cloud events in Yandex Query
    • Searching for Yandex Cloud events in Object Storage
    • Creating an external table from a bucket table using a configuration file
    • Migrating databases from Google BigQuery to Managed Service for ClickHouse®
  • Terraform reference
  • Monitoring metrics
  • Audit Trails events
  • Bucket logs
  • Release notes
  • FAQ

In this article:

  • Getting started
  • Connect to data in Object Storage
  • Create a connection in Yandex DataLens
  • Configure the dataset fields
  • Configure visualization
  1. Tutorials
  2. Visualizing Yandex Query data

Visualizing Yandex Object Storage data in Yandex DataLens

Written by
Yandex Cloud
Updated at May 7, 2025
  • Getting started
  • Connect to data in Object Storage
  • Create a connection in Yandex DataLens
  • Configure the dataset fields
  • Configure visualization

By integrating Yandex Query with Yandex DataLens, you can visualize data stored in Yandex Object Storage. DataLens generates a YQL query, while Yandex Query runs it and returns the results, which are visualized using charts.

Below is the architecture used thereby.

datalens-architecture

As an example, let's visualize how the time of day affects the number and average cost of New York City yellow taxi rides. The data was pre-uploaded to a public Yandex Object Storage bucket named yq-sample-data, in the nyc_taxi_csv folder.

Note

Yandex Cloud provides the New York City taxi trips dataset as is. Yandex Cloud makes no representations, express or implied, warranties, or conditions pertaining to your use of the specified dataset. To the extent allowed by your local laws, Yandex Cloud shall not be liable for any loss or damage, including direct, consequential, special, indirect, incidental, or exemplary, resulting from your use of the dataset.

NYC Taxi and Limousine Commission (TLC):

The data was collected and provided to the NYC Taxi and Limousine Commission (TLC) by technology providers authorized under the Taxicab & Livery Passenger Enhancement Programs (TPEP/LPEP). The taxi trip data is not generated by the TLC, and the TLC makes no representations whatsoever about the accuracy of this data.

Take a look at the Dataset source and its Use Policy.

To visualize and explore data, get your cloud ready and follow these steps:

  1. Connect to the data in Object Storage.
  2. Create a connection in Yandex DataLens.
  3. Configure the dataset fields.
  4. Configure visualization.

Getting startedGetting started

Sign up in Yandex Cloud and create a billing account:

  1. Navigate to the management console and log in to Yandex Cloud or register a new account.
  2. On the Yandex Cloud Billing page, make sure you have a billing account linked and it has the ACTIVE or TRIAL_ACTIVE status. If you do not have a billing account, create one and link a cloud to it.

If you have an active billing account, you can navigate to the cloud page to create or select a folder for your infrastructure to operate in.

Learn more about clouds and folders.

Note

To create a DataLens connection to Yandex Query, you will need a service accountwith the editor role for the folder where you will be creating the Object Storage bucket connection will be created.

Connect to data in Object StorageConnect to data in Object Storage

  1. In the management console, select the folder where you want to create a connection.

    select-catalog

  2. From the list of services, select Yandex Query.

    select-yq

  3. In the left-hand panel, select Tutorial.

  4. Click Create connection. In the Create connection section, all parameter fields have been pre-filled. Optionally, enter a description; then click Create. This will take you to the screen for creating a data binding.

  5. Optionally, enter the data binding description; then click Create. This will create the appropriate training resources.

Create a connection in Yandex DataLensCreate a connection in Yandex DataLens

To create a Yandex Query connection:

  1. Go to the DataLens home page.

  2. In the left-hand panel, select Connections and click Create connection.

  3. Select a Yandex Query connection.

  4. Specify the connection settings:

    • Cloud and folder. Select the folder where you keep your service account.
    • Service account. Select an existing service account or create a new one.
    • Cache TTL in seconds. Specify the cache time-to-live or leave the default value.
    • Raw SQL level. Select Allow subqueries from datasets and queries from charts.
  5. Click Create connection.

  6. Enter a connection name, e.g., yq-connect, and click Create.

Configure the dataset fieldsConfigure the dataset fields

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

    create-dataset

  2. In the window that opens, enter the query text below and click Create.

    SELECT 
        *
    FROM 
        bindings.`tutorial-analytics`
    

    If the configuration is correct, the Preview section in the lower part of the screen will contain the following data:

    dataset-results

  3. Create a calculated field with the pick-up time data:

    1. Navigate to the Fields tab and click Add field.

      create-field

    2. In Field name, specify hour_trip.

    3. In the formula line, enter:

      HOUR([tpep_pickup_datetime])
      
    4. Click Create. The new hour_trip field will appear in the list of dataset fields.

  4. In the Aggregation column, select the Average aggregation type for the total_amount field.

    field-agg

  5. In the top-right corner, click Save. Enter the dataset name, yellow-taxi-dataset, and click Create.

  6. Once the dataset is saved, click Create chart in the top-right corner.

    create-chart

Configure visualizationConfigure visualization

To visualize and analyze the data, use a combined chart.

  1. Select Combined chart as the visualization type.

    chart-type

  2. Drag the hour_trip dimension to the X section. The dimension in the X section will be common for all layers.

  3. For the first layer, select Bar chart.

    select-layer-column

  4. Drag the total_amount measure to the Y section. You will see a bar chart in the visualization area.

  5. Add a layer. To do this, click to the right of the first layer's name.

  6. For the second layer, select Line chart.

    select-layer-line

  7. Add a field to the chart:

    1. At the top left, click and select Field.

      chart-add-field

    2. In the window that opens:

      • Under Field name, enter count_trip.

      • In the formula line, enter COUNT().

        chart-field-create

    3. Click Create.

  8. Drag the new count_trip measure to the Y2 section. You will see a line chart on top of the first chart in the visualization area.

  9. In the top-right corner, click Save. Enter yellow-taxi-combo-chart as the chart name and click Save.

The chart you created shows how the time of day affects the number of trips (line chart) and the average ride cost (bar chart).

datalens-yq-combo-chart

In the same way, you can create additional charts and dashboards or share the results with your teammates.

Was the article helpful?

Previous
Terraform
Next
Publishing game updates
© 2025 Direct Cursus Technology L.L.C.