Connecting to DataLens
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:
- ClickHouse®
- MySQL
- PostgreSQL
- MS SQL Server
- Oracle Database
- YDB
- Greenplum®
- YTsaurus CHYT
- Files
- Yandex Documents
- Google Sheets
- BigQuery
- Prometheus
- Yandex Monitoring
- Bitrix24
- Podcasts Analytics
- Metrica
- AppMetrica
- Yandex Cloud Billing
You can add connections from the available list in DataLens Marketplace.
Warning
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):ipv4ipv6178.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 management
You can configure connection permissions. For more information, see Managing access to DataLens.
ClickHouse® is a registered trademark of ClickHouse, Inc