Managing connections
Written by
Updated at July 15, 2024
A connection is required for connecting Yandex Query to a data source and target.
Creating a connection
To create a connection:
-
In the management console
, select the folder where you want to create a connection. -
In the list of services, select Yandex Query.
-
In the left-hand panel, select Connections.
-
Click
Create new. -
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.
-
Select the connection type and specify the Connection type parameters:
Object StorageData StreamsManaged Service for PostgreSQLManaged Service for ClickHouse®Monitoring- Bucket auth:
Public
orPrivate
. - 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 to be used 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 to be used to access the data.
- 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 toManaged Service for PostgreSQL
clusters. - 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 ClickHouse® cluster or create a new one.
- Service account: Select an existing service account Managed Service for ClickHouse®, or create a new one with the
managed-clickhouse.viewer
role, and use it to connect toManaged Service for ClickHouse®
clusters. - Login: Username to use when connecting to ClickHouse® databases.
- Password: User password to use when connecting to ClickHouse® databases.
- Select the Cloud and Folder where the data source is located.
- Select or create a service account to be used to log metrics.
- Bucket auth:
-
Click Create.
To use a connection with a service account specified, the iam.serviceAccounts.user
role is required.
Next, you can create a binding.
Getting information about a connection
To view information about a connection:
- In the management console
, select the folder where the connection is created. - In the list of services, select Yandex Query.
- In the left-hand panel, select Connections.
- In the line 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 parameters
To edit connection parameters:
- In the management console
, select the folder where the connection is created. - In the list of services, select Yandex Query.
- In the left-hand panel, select Connections.
- In the line with the connection name, click
and select Edit. - Set new parameters for the connection. You cannot change the connection type.
- Click Modify.
Deleting a connection
To delete a connection:
- In the management console
, select the folder where the connection is created. - In the list of services, select Yandex Query.
- In the left-hand panel, select Connections.
- In the line with the connection name, click
and select Delete. - Confirm connection deletion.
ClickHouse® is a registered trademark of ClickHouse, Inc