Contact UsGet started

Connecting to a PostgreSQL cluster from DataLens

Written by
Updated at October 14, 2024

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:

  1. Activate DataLens.
  2. Enable access to the cluster from DataLens.
  3. Create a cluster connection in DataLens.

Activating DataLens

Limit

You can only create one DataLens instance in the cloud.

  1. In the management console, go to the folder page.
  2. Select DataLens.
  3. Click Activate DataLens.

The DataLens instance will be activated in the selected folder.

Allowing access to a cluster from DataLens

To enable DataLens to connect to your cluster and work with its data, activate the DataLens access option when creating a cluster or updating its settings.

Creating a connection to a cluster

  1. Make sure that DataLens is activated in the appropriate folder and you can access the cluster from it.

  2. Go to the folder page and select Managed Service for PostgreSQL.

  3. Click the cluster name and open the DataLens tab.

  4. 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 did not activate DataLens or connected it in a different folder. To connect your cluster to a DataLens instance from another folder, follow the guide in the DataLens documentation.

  5. Specify the connection settings.

  6. In the top-right corner, select the connection scope from the drop-down list:

    • Available only to me.
    • Available to the company.

  7. Check that the settings are correct by clicking Check connection.

  8. After successfully checking the connection, click Create connection.

  9. In the resulting window, enter a name for the connection and click Create.

Once the connection is created, you can:

Viewing a list of cluster connections

  1. Go to the folder page and select Managed Service for PostgreSQL.
  2. Click the cluster name and open the DataLens tab.

Updating a cluster connection

  1. Go to the folder page and select Managed Service for PostgreSQL.
  2. Click the cluster name and open the DataLens tab.
  3. Select a connection from the list.
  4. Edit the connection settings and scope.
  5. Check that the settings are correct by clicking Check connection.
  6. After successfully checking the connection, click Save changes.

Deleting a cluster connection

  1. Go to the folder page and select Managed Service for PostgreSQL.
  2. Click the cluster name and open the DataLens tab.
  3. Select a connection from the list.
  4. Click at the top of the page and select Delete.
  5. In the window that opens, click Delete.

Connection settings

  1. Specify a name for the connection.
  2. If the cluster and DataLens are in the same folder:
    1. Go to the Select in cloud tab.
    2. 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.
    3. Leave the Port setting value unchanged.
    4. Select a database name from the drop-down list.
    5. Select a user from the drop-down list.
    6. Enter this user's password.
    7. Specify the cache time-to-live or leave the default value. The recommended value is 300 seconds (5 minutes).
    8. Configure a Raw SQL level.
    9. To explicitly define a collation for DB queries, go to Advanced connection settings. Select a mode to configure Setting collate in a query:
      • Auto: Default setting is used, DataLens decides whether to enable the en_US locale.
      • On: DataLens setting is used, the en_US locale is specified for individual expressions in a query. This makes the server use the appropriate sorting logic, regardless of the server settings and specific tables. Use the DataLens setting if the DB locale is incompatible with DataLens performance. For more information on the locale and LC_COLLATE, see Creating a cluster.
      • Off: The default setting is used, DataLens only uses the existing parameters of the DB locale.
  3. If the cluster and DataLens are in different folders, use the settings from the instructions in the DataLens documentation.
Previous
Monitoring the state of clusters and hosts
Next
All tutorials