Connecting to a data source

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

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

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.