Connections

Do you support the PostgreSQL GEO type?Do you support the PostgreSQL GEO type?

DataLens does not support data types of the PostGIS extension that is used in PostgreSQL to work with geodata. Geopoint and Geopolygon are string types of certain formats.

How do I connect to Yandex Metrica from DataLens?How do I connect to Yandex Metrica from DataLens?

DataLens can connect to Yandex Metrica directly (see Web analytics with a connection to Yandex Metrica). In this case, you won't have access to some analytical functions for data (the data is accessed over an API with limited functionality). It is likely that the API will slowly respond to queries involving large amounts of data. If you are using the API very actively, you may exceed the API limits.

You can use scripts to set up export of the metric to your database and connect to this database using DataLens.

Previously, DataLens supported connection to Yandex Metrica and AppMetrica with prior data export to ClickHouse® via LogsAPI. Is this still possible?Previously, DataLens supported connection to Yandex Metrica and AppMetrica with prior data export to ClickHouse® via LogsAPI. Is this still possible?

No. Currently, only direct connections to Yandex Metrica and AppMetrica are available.

To work with raw Yandex.Metrica and AppMetrica data, you can:

• For AppMetrica, set up automatic raw data export to Managed Service for ClickHouse® directly in the AppMetrica interface.

• For Metrica:

  • Use the sample code from the documentation to export raw data to ClickHouse® via LogsAPI.
  • Add the Metrica Pro package and set up data transfer to a Managed Service for ClickHouse® cluster.

Why is it that when I upload a CSV file, I can only see the first 100 rows in the table, even though there are more?Why is it that when I upload a CSV file, I can only see the first 100 rows in the table, even though there are more?

This is a preview that lets you check that your data and delimiters were identified correctly. Showing too many rows might result in errors or slow down your browser. That's why we limited the number of rows displayed.

Why does it take so long to upload a CSV file?Why does it take so long to upload a CSV file?

At the moment, when you upload a file, several replicas are created in different data centers to ensure fault tolerance. This process takes some time.

Why does uploading a CSV file cause a network error?Why does uploading a CSV file cause a network error?

Try using a different browser and disabling ad blockers.

What do I do if a Google Sheets spreadsheet works incorrectly?What do I do if a Google Sheets spreadsheet works incorrectly?

If a Google Sheets spreadsheet contains empty cells, DataLens may incorrectly display column headers and miss the first several rows.

To fix this, you need to fill empty cells in your Google Sheets spreadsheet with any appropriate values, e.g., unavailable, none, unknown.

To quickly populate empty cells in a Google Sheets spreadsheet:

1. Highlight the entire Google Sheets sheet.
2. In the spreadsheet menu, select Data → Create a filter.
3. In the right-hand corner of the first column's top cell, click the filter icon.
4. Select Clear and then select (Blanks).
5. In the column's top cell, enter the desired values, such as 0, unavailable, none, or any other.
6. Drag the cell down to fill all the empty cells in the column with the entered value.
7. Click the filter icon again and click Select all.
8. Repeat all the steps starting with Step 3 for the other columns in the spreadsheet.

What do I do if I get the Invalid URL format error when connecting to Yandex Documents?What do I do if I get the Invalid URL format error when connecting to Yandex Documents?

This error occurs if the URL contains /d instead of /i. For example:

• https://disk.yandex.ru/i/id is the correct URL format.
• https://disk.yandex.ru/d/id is the incorrect URL format.

To fix the problem, delete the URL to your Yandex Documents file and after a while generate a new one.

ClickHouse® is a registered trademark of ClickHouse, Inc.