Connecting to a data source

Connections contain information about data source access parameters, such as the DB host IP address and port.

In a single connection, only one data source can be described.

You can create datasets based on connections.

The following connection types are available in DataLens:

• Databases:

  • ClickHouse®
  • PostgreSQL
  • MySQL®
  • YDB
  • YTsaurus CHYT
  • Greenplum®
  • MS SQL Server
  • Oracle Database
  • Prometheus
  • Snowflake

• Files and services:

  • Files
  • Yandex Documents
  • Google Sheets
  • Yandex Query
  • Metrica
  • AppMetrica
  • Yandex Cloud Billing
  • Yandex Monitoring
  • DataLens Usage Analytics

• Partner connections:

  • 1C Extractor
  • Bitrix24
  • Analystics podcasts

You can add connections from the available list in DataLens Marketplace.

Connecting an external databaseConnecting an external database

Yandex Cloud holds no responsibility for configuring a remote connection on an external database server side. When connecting an external database which is not a Yandex Cloud resource:

• Make sure the database uses an SSL certificate signed by a SSL certificate authority. You will not be able to create a connection in DataLens if the database uses a self-signed SSL certificate.

• Grant database access to the following DataLens IP ranges (/ is followed by subnet mask length):

  ipv4

  ipv6

  • 178.154.242.176/28
  • 178.154.242.192/28
  • 178.154.242.208/28
  • 178.154.242.128/28
  • 178.154.242.144/28
  • 178.154.242.160/28
  • 130.193.60.0/28

  • 2a02:6b8:c03:500:0:f83d:a987:0/112
  • 2a02:6b8:c02:900:0:f83d:a987:0/112
  • 2a02:6b8:c0e:500:0:f83d:a987:0/112
  • 2a02:6b8:c41:1300:0:f83d:a987:0/112

Access managementAccess management

You can configure connection permissions. For more information, see Managing access to DataLens.

ClickHouse® is a registered trademark of ClickHouse, Inc.