Managing connections

Yandex Query connections are necessary to access data sources and sinks.

Creating a connectionCreating a connection

To create a connection:

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

2. Navigate to Yandex Query.

3. In the left-hand panel, select Connections.

4. Click Create new.

5. Specify the connection name and description. The naming requirements are as follows:

   • The name must consist of lowercase Latin letters.
   • It must be between 3 and 63 characters in length.
   • It may contain digits and hyphens.
   • It must start with a letter and cannot end with a hyphen.

6. Select the connection type and specify the Connection type parameters:

   Object Storage

   Data Streams

   Managed Service for ClickHouse®

   Yandex MPP Analytics for PostgreSQL

   Managed Service for MySQL®

   Managed Service for PostgreSQL

   Managed Service for YDB

   Monitoring

   • Bucket auth: Public or Private.
   • For a public bucket, specify a name in the Bucket field.
     For a private bucket:
     • Select Cloud and Folder where the data source is located.
     • Select an existing bucket or create a new one.
     • Select an existing or create a new service account. You will use it to access the data.

   • Select the Cloud and Folder where the data source is located.
   • Select or create a new serverless Managed Service for YDB database with a Yandex Data Streams stream.
   • Select an existing or create a new service account. You will use it to access the data.

   • Cluster: Select an existing Managed Service for ClickHouse® cluster or create a new one.
   • Service account: Select an existing Managed Service for ClickHouse® service account or create a new one. Assign it the managed-clickhouse.viewer role allowing it to connect to Managed Service for ClickHouse® clusters.
   • Database: Select the database you will use when working with the ClickHouse® cluster.
   • Login: Username you will use to connect to ClickHouse® databases.
   • Password: Password you will use to connect to ClickHouse® databases.

   • Cluster: Select an existing Yandex MPP Analytics for PostgreSQL cluster or create a new one.
   • Service account: Select an existing Yandex MPP Analytics for PostgreSQL service account or create a new one. Assign it the managed-greenplum.viewer role allowing it to connect to Yandex MPP Analytics for PostgreSQL clusters.
   • Database: Select the database you will use when working with the Greenplum® cluster.
   • Schema: Specify the namespace you will use when working with the Greenplum® database.
   • Login: Username you will use to connect to Greenplum® databases.
   • Password: Password you will use to connect to Greenplum® databases.

   • Cluster: Select an existing Managed Service for MySQL® cluster or create a new one.
   • Service account: Select an existing Managed Service for MySQL® service account or create a new one. Assign it the managed-mysql.viewer role allowing it to connect to Managed Service for MySQL® clusters.
   • Database: Select the database you will use when working with the MySQL® cluster.
   • Login: Username you will use to connect to MySQL® databases.
   • Password: Password you will use to connect to MySQL® databases.

   • Cluster: Select an existing Managed Service for PostgreSQL cluster or create a new one.
   • Service account: Select an existing Managed Service for PostgreSQL service account or create a new one. Assign it the managed-postgresql.viewer role allowing it to connect to Managed Service for PostgreSQL clusters.
   • Database: Select the database you will use when working with the PostgreSQL cluster.
   • Login: Username you will use to connect to PostgreSQL databases.
   • Password: Password you will use to connect to PostgreSQL databases.

   • Cluster: Select an existing Managed Service for YDB database or create a new one.
   • Service account: Select the Managed Service for YDB service account you will use for Managed Service for YDB cluster connections and database authentication.

   • Select the Cloud and Folder where the data source is located.
   • Select or create a new service account that will be used for writing metrics.

7. Click Create.

To use a connection with this service account, you need the iam.serviceAccounts.user role.

Now, you can create a binding.

Getting connection detailsGetting connection details

To view connection details:

1. In the management console, select the folder where you have created the connection.
2. Navigate to Yandex Query.
3. In the left-hand panel, select Connections.
4. Find the connection you need in the list and click in its row. The source and service account details will appear under General. The connection ID, creation timestamp, and creator will appear under Meta.

Modifying connection settingsModifying connection settings

To edit connection settings:

1. In the management console, select the folder where you have created the connection.
2. Navigate to Yandex Query.
3. In the left-hand panel, select Connections.
4. Find the connection you need in the list, click in its row, and select Edit.
5. Update the connection settings. Note that the connection type is read-only.
6. Click Modify.

Deleting a connectionDeleting a connection

To delete a connection:

1. In the management console, select the folder where you have created the connection.
2. Navigate to Yandex Query.
3. In the left-hand panel, select Connections.
4. Find the connection you need in the list, click in its row, and select Delete.
5. Confirm connection deletion.

ClickHouse® is a registered trademark of ClickHouse, Inc.