Connecting to a MySQL® cluster from DataLens
Yandex DataLens is a business intelligence service, that lets you upload, process and visualize data for analysing and testing hypotheses. It can help you make marketing decisions for your product.
To use an existing cluster as a data source for Yandex DataLens:
- Activate DataLens.
- Enable access to the cluster from DataLens.
- Create a cluster connection in DataLens.
Activating DataLens
Limit
You can only create one DataLens instance in the cloud.
- In the management console, go to the folder page.
- Go to DataLens.
- Click Activate DataLens.
The DataLens instance will be activated in the selected folder.
Enabling access to a cluster from DataLens
To enable DataLens to connect to your cluster and work with its data, enable DataLens access when creating or reconfiguring the cluster.
Creating a cluster connection
-
Make sure DataLens is activated in the relevant folder and has permission to access the cluster.
-
Go to Managed Service for MySQL.
-
Click the cluster name and select the DataLens tab.
-
Click Create connection.
I have no Create connection button
If you see a message saying DataLens not activated instead of the Create connection button, it means that you either have not activated DataLens yet or have activated it in a different folder. To connect your cluster to a DataLens instance from another folder, follow this DataLens guide.
-
In the top-right corner, select the connection scope from the drop-down list:
- Available only to me.
- Available to the company.
-
Check that the settings are correct by clicking Check connection.
-
After a successful check, click Create connection.
-
Specify a name for the connection.
-
Click Create.
After creating the connection, you can:
- Update or delete this connection.
- Use this connection to create datasets from the cluster data.
- Visualize the datasets using charts and dashboards.
Viewing a list of cluster connections
- Go to Managed Service for MySQL.
- Click the cluster name and select the DataLens tab.
Updating a cluster connection
Deleting a cluster connection
- Go to Managed Service for MySQL.
- Click the name of your cluster and open the DataLens tab.
- Select the connection from the list.
- Click at the top of the page and select Delete.
- In the window that opens, click Delete.
Connection settings
If your cluster and DataLens are in the same folder:
- Open the Select in folder tab.
- Select the cluster and its host from the drop-down lists or create a new cluster in the folder with DataLens by clicking Create new.
- Select the database and user from the drop-down lists.
- Enter the user password. See also Creating a connection to MySQL® in Yandex DataLens and Configuring access in the DataLens documentation.
If your cluster and DataLens are in different folders:
- Navigate to the Specify manually tab.
- Use the settings from this DataLens guide.