Managing connections
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 ClickHouse®Managed Service for Greenplum®Managed Service for MySQL®Managed Service for PostgreSQLManaged Service for YDBMonitoring- 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 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 toManaged 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 toManaged 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 toManaged 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 toManaged 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.
- Bucket auth:
-
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 connection
To view information about a connection:
- In the management console
, select the folder where the connection was created. - In the list of services, select Yandex Query.
- In the left-hand panel, select Connections.
- 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 parameters
To edit connection parameters:
- In the management console
, select the folder where the connection was created. - In the list of services, select Yandex Query.
- In the left-hand panel, select Connections.
- In the row with the appropriate 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 was created. - In the list of services, select Yandex Query.
- In the left-hand panel, select Connections.
- In the row with the appropriate connection name, click
and select Delete. - Confirm connection deletion.
ClickHouse® is a registered trademark of ClickHouse, Inc