Managing connections

A connection is required for Yandex Query to access data sources and targets.

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. In the list of services, select Yandex Query.

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

4. Click Create new.

5. Enter a name and description for the connection. The naming requirements are as follows:

   • The name must be in lowercase Latin letters.
   • Length: between 3 and 63 characters.
   • It may contain digits and hyphens.
   • The first character must be a letter, the last one cannot be a hyphen.

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

   Object Storage

   Data Streams

   Managed Service for ClickHouse®

   Managed Service for Greenplum®

   Managed Service for MySQL®

   Managed Service for PostgreSQL

   Managed Service for YDB

   Monitoring

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

   • Select the Cloud and Folder where the data source is located.
   • Select or create a serverless Managed Service for YDB database with a Yandex Data Streams stream.
   • Select or create a service account you will use 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 with the managed-clickhouse.viewer role to connect to Managed Service for ClickHouse® clusters.
   • Database: Select the database you will use when working with the ClickHouse® cluster.
   • Login: Username to use when connecting to ClickHouse® databases.
   • Password: User password to use when connecting to ClickHouse® databases.

   • Cluster: Select an existing Managed Service for Greenplum® cluster or create a new one.
   • Service account: Select an existing Managed Service for Greenplum® service account, or create a new one with the managed-greenplum.viewer role, and use it to connect to Managed Service for Greenplum® clusters.
   • Database: Select the database you will use when working with the Greenplum® cluster.
   • Schema: Specify the namespace to use when working with the Greenplum® database.
   • Login: Username to use when connecting to Greenplum® databases.
   • Password: User password to use when connecting 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 with the managed-mysql.viewer role, and use it to connect to Managed Service for MySQL® clusters.
   • Database: Select the database you will use when working with the MySQL® cluster.
   • Login: Username to use when connecting to MySQL® databases.
   • Password: User password to use when connecting 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 with the managed-postgresql.viewer role to connect to Managed Service for PostgreSQL clusters.
   • Database: Select the database you will use when working with the PostgreSQL cluster.
   • Login: Username to use when connecting to PostgreSQL databases.
   • Password: User password to use when connecting 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 to use for connecting to Managed Service for YDB clusters and database authentication.

   • Select the Cloud and Folder where the data source is located.
   • Select or create a service account to use for logging metrics.

7. Click Create.

To use a connection with a service account specified, the user should have the iam.serviceAccounts.user role.

Next, you can create a binding.

Getting information about a connectionGetting information about a connection

To view information about a connection:

1. In the management console, select the folder where the connection was created.
2. In the list of services, select Yandex Query.
3. In the left-hand panel, select Connections.
4. In the row with the connection name, click . You can find information about the source and service account under General. In the Meta section, you can view the connection ID, creation timestamp, and creator.

Changing connection parametersChanging connection parameters

To edit connection parameters:

1. In the management console, select the folder where the connection was created.
2. In the list of services, select Yandex Query.
3. In the left-hand panel, select Connections.
4. In the row with the appropriate connection name, click and select Edit.
5. Set new parameters for the connection. You cannot change the connection type.
6. Click Modify.

Deleting a connectionDeleting a connection

To delete a connection:

1. In the management console, select the folder where the connection was created.
2. In the list of services, select Yandex Query.
3. In the left-hand panel, select Connections.
4. In the row with the appropriate connection name, click and select Delete.
5. Confirm connection deletion.

ClickHouse® is a registered trademark of ClickHouse, Inc.