Connection
Written by
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
- PostgreSQL
- MySQL
- CSV file
- Google Sheets
- MS SQL Server
- Oracle Database
- YDB
- Greenplum
- Metrica (in direct access mode)
- AppMetrica (in direct access mode)
- Yandex Cloud Billing
You can add connections from the available list in DataLens Marketplace.
Warning
When connecting an external DB that is not a Yandex Cloud resource, grant database access to the following IP ranges belonging to DataLens (the / character separates the subnet mask):
ipv4
ipv6
178.154.242.176/28178.154.242.192/28178.154.242.208/28178.154.242.128/28178.154.242.144/28178.154.242.160/28
2a02:6b8:c03:500:0:f83d:a987:0/1122a02:6b8:c02:900:0:f83d:a987:0/1122a02:6b8:c0e:500:0:f83d:a987:0/112
Access management
You can configure connection permissions. For more information, see Managing access to DataLens.
See also
- Creating a ClickHouse connection
- Creating a connection to a CSV file
- Creating a Google Sheets connection
- Creating a MySQL connection
- Creating a PostgreSQL connection
- Creating an MS SQL Server connection
- Creating an Oracle Database connection
- Creating a Metrica connection
- Creating an AppMetrica connection
- Creating a Yandex Cloud Billing connection