Contact UsGet started
© 2025 Direct Cursus Technology L.L.C.

Creating a connection

Written by
Updated at May 5, 2025

Note

This feature is at the Preview stage.

You can create connections of the following types:

Connecting to a cluster with a managed database

Managed Service for PostgreSQL

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select Connection type.
  8. Under Connection to PostgreSQL, select Managed Service for PostgreSQL cluster as the connection type and specify the cluster you need.
  9. Under Authentication:
    1. Specify the Username you will use to connect to the cluster.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You can connect only to the databases that exist in the cluster. You must have access to them configured.
  11. Click Create.

Managed Service for ClickHouse®

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select Connection type.
  8. Under Connection to ClickHouse®, select Managed Service for ClickHouse® cluster as the connection type and specify the cluster you need.
  9. Under Authentication:
    1. Specify the Username you will use to connect to the cluster.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

Managed Service for MySQL®

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select Connection type.
  8. Under Connection to MySQL®, select Managed Service for MySQL® cluster as the connection type and specify the cluster you need.
  9. Under Authentication:
    1. Specify the Username you will use to connect to the cluster.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You can connect only to the databases that exist in the cluster. You must have access to them configured.
  11. Click Create.

Yandex Managed Service for Valkey™

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. From the Connection type list, select Valkey™.
  8. Under Connection to Valkey™, select Yandex Managed Service for Valkey™ cluster as the connection type and specify the cluster you need.
  9. Under Authentication, select how to set the password:
    • Enter manually: Enter the password manually.
    • Generate: Specify the options to generate a Lockbox password automatically.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

Managed Service for OpenSearch

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select Connection type.
  8. Under Connection to OpenSearch, select Managed Service for OpenSearch cluster as the connection type and specify the cluster you need.
  9. Under Authentication:
    1. Specify the Username you will use to connect to the cluster.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You can connect only to the databases that exist in the cluster. You must have access to them configured.
  11. Click Create.

Managed Service for MongoDB

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select Connection type.
  8. Under Connection to MongoDB, select Managed Service for MongoDB cluster as the connection type and specify the cluster you need.
  9. Under Authentication:
    1. Specify the Username you will use to connect to the cluster.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You can connect only to the databases that exist in the cluster. You must have access to them configured.
  11. Click Create.

Connecting to a custom database installation

PostgreSQL

  1. In the management console, select the folder you want to create a connection in.

  2. Select Yandex MetaData Hub.

  3. In the left-hand panel, select Connection manager.

  4. Click Create connection.

  5. Specify the connection name.

  6. (Optional) Add a description and label for the connection.

  7. Select Connection type.

  8. Under Connection to PostgreSQL, specify the connection parameters:

    1. In the Connection type field, select Custom installation.

    2. In the Hosts field, specify the database host address and port number for the connection.

      When creating a connection to a custom database installation intended for Yandex DataLens, specify the host's external address.

    3. (Optional) Enable TLS.
      If your company has a certification authority (CA), the certificate issued by that CA will be used by default. If the company has no CA, upload the server's TLS certificate.

  9. Under Authentication:

    1. Specify the Username you will use to connect to the database.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.

  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.

  11. Click Create.

ClickHouse®

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select Connection type.
  8. Under Connection to ClickHouse®, specify the connection parameters:

    1. In the Connection type field, select Custom installation.

    2. In the Hosts field, specify the FQDNs or IP addresses of the hosts in the shard, HTTP or TCP port for connection, and the shard name.

      When creating a connection to a custom database installation intended for Yandex DataLens, specify the the hosts’ external IP addresses.

    3. (Optional) Enable TLS.
      If your company has a certification authority (CA), the certificate issued by that CA will be used by default. If the company has no CA, upload the server's TLS certificate.

  9. Under Authentication:
    1. Specify the Username you will use to connect to the database.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

MySQL®

  1. In the management console, select the folder you want to create a connection in.

  2. Select Yandex MetaData Hub.

  3. In the left-hand panel, select Connection manager.

  4. Click Create connection.

  5. Specify the connection name.

  6. (Optional) Add a description and label for the connection.

  7. Select Connection type.

  8. Under Connection to MySQL®, specify the connection parameters:

    1. In the Connection type field, select Custom installation.

    2. In the Hosts field, specify the database host address and port number for the connection.

      When creating a connection to a custom database installation intended for Yandex DataLens, specify the host's external address.

    3. (Optional) Enable TLS.
      If your company has a certification authority (CA), the certificate issued by that CA will be used by default. If the company has no CA, upload the server's TLS certificate.

  9. Under Authentication:

    1. Specify the Username you will use to connect to the database.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.

  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.

  11. Click Create.

Valkey™

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. From the Connection type list, select Valkey™.
  8. Under Connection to Valkey™, specify the connection parameters:
    1. In the Connection type field, select Custom installation.
    2. In the Hosts field, specify the FQDNs or IP addresses of the hosts in the shard, HTTP or TCP port for connection, and the shard name.
    3. (Optional) Enable TLS.
  9. Under Authentication, specify a username and select how you want to set the password:
    • Enter manually: Enter the password manually.
    • Generate: Specify the options to generate a Lockbox password automatically.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

Valkey™

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. From the Connection type list, select Valkey™.
  8. Under Connection to Valkey™, specify the connection parameters:

    1. In the Connection type field, select Custom installation.

    2. In the Hosts field, specify the FQDNs or IP addresses of the hosts in the shard, HTTP or TCP port for connection, and the shard name.

      When creating a connection to a custom database installation intended for Yandex DataLens, specify the the hosts’ external IP addresses.

    3. (Optional) Enable TLS.

  9. Under Authentication, specify a username and select how you want to set the password:
    • Enter manually: Enter the password manually.
    • Generate: Specify the options to generate a Lockbox password automatically.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

Trino

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select Connection type.
  8. Under Connection to Trino, specify the connection parameters:
    1. In the Coordinator field, specify the coordinator host address and port number for the connection.
    2. (Optional) Enable TLS.
      If your company has a certification authority (CA), the certificate issued by that CA will be used by default. If the company has no CA, upload the server's TLS certificate.
  9. Under Authentication:
    1. Specify the Username you will use to connect to the database.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. Click Create.

OpenSearch

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select Connection type.
  8. Under Connection to OpenSearch, specify the connection parameters:
    1. In the Connection type field, select Custom installation.
    2. In the Hosts field, specify the database host address and port number for the connection.
    3. (Optional) Enable TLS.
      If your company has a certification authority (CA), the certificate issued by that CA will be used by default. If the company has no CA, upload the server's TLS certificate.
  9. Under Authentication:
    1. Specify the Username you will use to connect to the database.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

MongoDB

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select Connection type.
  8. Under Connection to MongoDB, specify the connection parameters:
    1. In the Connection type field, select Custom installation.
    2. In the Hosts field, specify the database host address and port number for the connection.
    3. (Optional) Enable TLS.
      If your company has a certification authority (CA), the certificate issued by that CA will be used by default. If the company has no CA, upload the server's TLS certificate.
  9. Under Authentication:
    1. Specify the Username you will use to connect to the database.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

ClickHouse® is a registered trademark of ClickHouse, Inc.

Previous
All guides
Next
Viewing a connection