ClusterService

A set of methods for managing ClickHouse clusters.

Call	Description
Get	Returns the specified ClickHouse cluster.
List	Retrieves a list of ClickHouse clusters that belong to the specified folder.
Create	Creates a ClickHouse cluster in the specified folder.
Update	Updates the specified ClickHouse cluster.
Delete	Deletes the specified ClickHouse cluster.
Start	Starts the specified ClickHouse cluster.
Stop	Stops the specified ClickHouse cluster.
Move	Moves a ClickHouse cluster to the specified folder.
AddZookeeper	Adds a ZooKeeper subcluster to the specified ClickHouse cluster.
Backup	Creates a backup for the specified ClickHouse cluster.
Restore	Creates a new ClickHouse cluster using the specified backup.
RescheduleMaintenance	Reschedule planned maintenance operation.
ListLogs	Retrieves logs for the specified ClickHouse cluster.
StreamLogs	Same as ListLogs but using server-side streaming.
ListOperations	Retrieves the list of Operation resources for the specified cluster.
ListBackups	Retrieves the list of available backups for the specified ClickHouse cluster.
ListHosts	Retrieves a list of hosts for the specified cluster.
AddHosts	Creates new hosts for a cluster.
DeleteHosts	Deletes the specified hosts for a cluster.
GetShard	Returns the specified shard.
ListShards	Retrieves a list of shards that belong to the specified cluster.
AddShard	Creates a new shard in the specified cluster.
UpdateShard	Modifies the specified shard.
DeleteShard	Deletes the specified shard.
GetShardGroup	Returns the specified shard group.
ListShardGroups	Retrieves a list of shard groups that belong to specified cluster.
CreateShardGroup	Creates a new shard group in the specified cluster.
UpdateShardGroup	Modifies the specified shard group.
DeleteShardGroup	Deletes the specified shard group.
CreateExternalDictionary	Creates an external dictionary for the specified ClickHouse cluster.
DeleteExternalDictionary	Deletes the specified external dictionary.

Calls ClusterService

Get

Returns the specified ClickHouse cluster.
To get the list of available ClickHouse clusters, make a List request.

rpc Get (GetClusterRequest) returns (Cluster)

GetClusterRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse Cluster resource to return. To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

List

Retrieves a list of ClickHouse clusters that belong to the specified folder.

rpc List (ListClustersRequest) returns (ListClustersResponse)

ListClustersRequest

Field	Description
folder_id	string Required. ID of the folder to list ClickHouse clusters in. To get the folder ID, use a yandex.cloud.resourcemanager.v1.FolderService.List request. The maximum string length in characters is 50.
page_size	int64 The maximum number of results per page to return. If the number of available results is larger than page_size, the service returns a ListClustersResponse.next_page_token that can be used to get the next page of results in subsequent list requests. The maximum value is 1000.
page_token	string Page token. To get the next page of results, set page_token to the ListClustersResponse.next_page_token returned by a previous list request. The maximum string length in characters is 100.
filter	string The field name. Currently you can only use filtering with the Cluster.name field. An operator. Can be either = or != for single values, IN or NOT IN for lists of values. The value. Мust be 1-63 characters long and match the regular expression ^[a-zA-Z0-9_-]+$. The maximum string length in characters is 1000.

ListClustersResponse

Field	Description
clusters[]	Cluster List of ClickHouse Cluster resources.
next_page_token	string This token allows you to get the next page of results for list requests. If the number of results is larger than ListClustersRequest.page_size, use the next_page_token as the value for the ListClustersRequest.page_token parameter in the next list request. Each subsequent list request will have its own next_page_token to continue paging through the results.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

Create

Creates a ClickHouse cluster in the specified folder.

rpc Create (CreateClusterRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:CreateClusterMetadata

    Operation.response:Cluster

CreateClusterRequest

Field	Description
folder_id	string Required. ID of the folder to create the ClickHouse cluster in. The maximum string length in characters is 50.
name	string Required. Name of the ClickHouse cluster. The name must be unique within the folder. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.
description	string Description of the ClickHouse cluster. The maximum string length in characters is 256.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource. For example, "project": "mvp" or "source": "dictionary". No more than 64 per resource. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]*. The maximum string length in characters for each key is 63. Each key must match the regular expression [a-z][-_0-9a-z]*.
environment	Cluster.Environment Required. Deployment environment of the ClickHouse cluster.
config_spec	ConfigSpec Required. Configuration and resources for hosts that should be created for the ClickHouse cluster.
database_specs[]	DatabaseSpec Descriptions of databases to be created in the ClickHouse cluster. The number of elements must be greater than 0.
user_specs[]	UserSpec Descriptions of database users to be created in the ClickHouse cluster. The number of elements must be greater than 0.
host_specs[]	HostSpec Individual configurations for hosts that should be created for the ClickHouse cluster. The number of elements must be greater than 0.
network_id	string Required. ID of the network to create the cluster in. The maximum string length in characters is 50.
shard_name	string Name of the first shard in cluster. If not set, defaults to the value 'shard1'. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
security_group_ids[]	string User security groups

ConfigSpec

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resources for a ClickHouse server.
zookeeper	Zookeeper Configuration and resources for a ZooKeeper server.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services. If you want a specific service to access the ClickHouse cluster, then set the necessary values in this policy.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.
admin_password	string Password for user 'admin' that has SQL user management access.

Clickhouse

Field	Description
config	config.ClickhouseConfig Configuration for a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts. If not set, minimal available resources will be used. All available resource presets can be retrieved with a ResourcePresetService.List request.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

DatabaseSpec

Field	Description
name	string Required. Name of the ClickHouse database. 1-63 characters long. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

UserSpec

Field	Description
name	string Required. Name of the ClickHouse user. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_]*.
password	string Required. Password of the ClickHouse user. The string length in characters must be 8-128.
permissions[]	Permission Set of permissions to grant to the user.
settings	UserSettings
quotas[]	UserQuota Set of quotas assigned to the user.

Permission

Field	Description
database_name	string Name of the database that the permission grants access to.

UserSettings

Field	Description
readonly	google.protobuf.Int64Value 0 (default)—no restrictions. 1—only read data queries are allowed. 2—read data and change settings queries are allowed. Acceptable values are 0 to 2, inclusive.
allow_ddl	google.protobuf.BoolValue Determines whether DDL queries are allowed (e.g., CREATE, ALTER, RENAME, etc). Default value: true. See in-depth description in ClickHouse documentation.
insert_quorum	google.protobuf.Int64Value replicas with no errors until the insert_quorum_timeout expires. queries. The minimum value is 0.
connect_timeout	google.protobuf.Int64Value (default: 10000, 10 seconds). Value must be greater than 0.
receive_timeout	google.protobuf.Int64Value (default: 300000, 300 seconds or 5 minutes). Value must be greater than 0.
send_timeout	google.protobuf.Int64Value (default: 300000, 300 seconds or 5 minutes). Value must be greater than 0.
insert_quorum_timeout	google.protobuf.Int64Value query and return an error. The minimum value is 1000.
select_sequential_consistency	google.protobuf.BoolValue queries from the replicated table: if enabled, ClickHouse will terminate a query with error message in case the replica does not have a chunk written with the quorum and will not read the parts that have not yet been written with the quorum. (sequential consistency is disabled).
max_replica_delay_for_distributed_queries	google.protobuf.Int64Value Max replica delay in milliseconds. If a replica lags more than the set value, this replica is not used and becomes a stale one. Minimum value: 1000, 1 second (default: 300000, 300 seconds or 5 minutes). See in-depth description in ClickHouse documentation. The minimum value is 1000.
fallback_to_stale_replicas_for_distributed_queries	google.protobuf.BoolValue query from a distributed table that points to replicated tables. (query forcing is enabled).
replication_alter_partitions_sync	google.protobuf.Int64Value queries on replicated tables: 0—do not wait for replicas. 1—only wait for own execution (default). 2—wait for all replicas. Acceptable values are 0 to 2, inclusive.
distributed_product_mode	enum DistributedProductMode Determine the behavior of distributed subqueries. See in-depth description in ClickHouse documentation. DISTRIBUTED_PRODUCT_MODE_DENY: Default value. Prohibits using these types of subqueries (returns the "Double-distributed in/JOIN subqueries is denied" exception). DISTRIBUTED_PRODUCT_MODE_LOCAL: Replaces the database and table in the subquery with local ones for the destination server (shard), leaving the normal IN/JOIN. DISTRIBUTED_PRODUCT_MODE_GLOBAL: Replaces the IN/JOIN query with GLOBAL IN/GLOBAL JOIN. DISTRIBUTED_PRODUCT_MODE_ALLOW: Allows the use of these types of subqueries.
distributed_aggregation_memory_efficient	google.protobuf.BoolValue (memory saving mode is disabled).
distributed_ddl_task_timeout	google.protobuf.Int64Value Timeout for DDL queries, in milliseconds.
skip_unavailable_shards	google.protobuf.BoolValue (silent skipping is disabled).
compile	google.protobuf.BoolValue (compilation is disabled).
min_count_to_compile	google.protobuf.Int64Value (default: 3). value compilation is synchronous: a query waits for compilation process to complete prior to continuing execution. The minimum value is 0.
compile_expressions	google.protobuf.BoolValue (expression compilation is disabled).
min_count_to_compile_expression	google.protobuf.Int64Value (default: 3). value compilation is synchronous: a query waits for expression compilation process to complete prior to continuing execution. The minimum value is 0.
max_block_size	google.protobuf.Int64Value (default: 65536). Value must be greater than 0.
min_insert_block_size_rows	google.protobuf.Int64Value query. The minimum value is 0.
min_insert_block_size_bytes	google.protobuf.Int64Value query. The minimum value is 0.
max_insert_block_size	google.protobuf.Int64Value (default: 1048576). Value must be greater than 0.
min_bytes_to_use_direct_io	google.protobuf.Int64Value Limits the minimum number of bytes to enable unbuffered direct reads from disk (Direct I/O). By default, ClickHouse does not read data directly from disk, but relies on the filesystem and its cache instead. Such reading strategy is effective when the data volume is small. If the amount of the data to read is huge, it is more effective to read directly from the disk, bypassing the filesystem cache. If the total amount of the data to read is greater than the value of this setting, then ClickHouse will fetch this data directly from the disk. Minimal value and default value: 0, Direct I/O is disabled. The minimum value is 0.
use_uncompressed_cache	google.protobuf.BoolValue (uncompressed cache is disabled).
merge_tree_max_rows_to_use_cache	google.protobuf.Int64Value (default: 128x8192). Value must be greater than 0.
merge_tree_max_bytes_to_use_cache	google.protobuf.Int64Value (default: 192x10x1024x1024). Value must be greater than 0.
merge_tree_min_rows_for_concurrent_read	google.protobuf.Int64Value (default: 20x8192). Value must be greater than 0.
merge_tree_min_bytes_for_concurrent_read	google.protobuf.Int64Value (default: 24x10x1024x1024). Value must be greater than 0.
max_bytes_before_external_group_by	google.protobuf.Int64Value operation, should be flushed to disk to limit the RAM comsumption. in the external memory is disabled.
max_bytes_before_external_sort	google.protobuf.Int64Value This setting is equivalent of the max_bytes_before_external_group_by setting, except for it is for sort operation (ORDER BY), not aggregation.
group_by_two_level_threshold	google.protobuf.Int64Value Sets the threshold of the number of keys, after that the two-level aggregation should be used. Minimal value: 0, threshold is not set (default: 10000‬‬).
group_by_two_level_threshold_bytes	google.protobuf.Int64Value Sets the threshold of the number of bytes, after that the two-level aggregation should be used. Minimal value: 0, threshold is not set (default: 100000000‬‬).
priority	google.protobuf.Int64Value 0—priority is not used. 1—the highest priority. and so on. The higher the number, the lower a query's priority. The minimum value is 0.
max_threads	google.protobuf.Int64Value (the thread number is calculated automatically based on the number of physical CPU cores, no HyperThreading cores are taken into account). Value must be greater than 0.
max_memory_usage	google.protobuf.Int64Value (10 GB). The minimum value is 0.
max_memory_usage_for_user	google.protobuf.Int64Value Limits the maximum memory usage (in bytes) for processing of user's queries on a single server. This setting does not take server's free RAM amount or total RAM amount into account. This limitation is enforced for all queries that belong to one user and run simultaneously on a single server. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
max_network_bandwidth	google.protobuf.Int64Value The maximum speed of data exchange over the network in bytes per second for a query. Minimal value and default value: 0, no limitation is set.
max_network_bandwidth_for_user	google.protobuf.Int64Value The maximum speed of data exchange over the network in bytes per second for all concurrently running user queries. Minimal value and default value: 0, no limitation is set.
force_index_by_date	google.protobuf.BoolValue (setting is disabled, query executes even if ClickHouse can't use index by date).
force_primary_key	google.protobuf.BoolValue (setting is disabled, query executes even if ClickHouse can't use index by primary key).
max_rows_to_read	google.protobuf.Int64Value Limits the maximum number of rows that can be read from a table when running a query. Minimal value and default value: 0, no limitation is set. See in-depth description in ClickHouse documentation. The minimum value is 0.
max_bytes_to_read	google.protobuf.Int64Value Limits the maximum number of bytes (uncompressed data) that can be read from a table when running a query. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
read_overflow_mode	enum OverflowMode throw—abort query execution, return an error. break—stop query execution, return partial result.
max_rows_to_group_by	google.protobuf.Int64Value Limits the maximum number of unique keys received from aggregation function. This setting helps to reduce RAM consumption while doing aggregation. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
group_by_overflow_mode	enum GroupByOverflowMode throw—abort query execution, return an error. break—stop query execution, return partial result. any—perform approximate GROUP BY operation by continuing aggregation for the keys that got into the set, but don’t add new keys to the set.
max_rows_to_sort	google.protobuf.Int64Value Limits the maximum number of rows that can be read from a table for sorting. This setting helps to reduce RAM consumption. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
max_bytes_to_sort	google.protobuf.Int64Value Limits the maximum number of bytes (uncompressed data) that can be read from a table for sorting. This setting helps to reduce RAM consumption. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
sort_overflow_mode	enum OverflowMode throw—abort query execution, return an error. break—stop query execution, return partial result.
max_result_rows	google.protobuf.Int64Value Limits the number of rows in the result. This limitation is also checked for subqueries and parts of distributed queries that run on remote servers. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
max_result_bytes	google.protobuf.Int64Value Limits the number of bytes in the result. This limitation is also checked for subqueries and parts of distributed queries that run on remote servers. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
result_overflow_mode	enum OverflowMode throw—abort query execution, return an error. break—stop query execution, return partial result.
max_rows_in_distinct	google.protobuf.Int64Value Limits the maximum number of different rows when using DISTINCT. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
max_bytes_in_distinct	google.protobuf.Int64Value Limits the maximum size of a hash table in bytes (uncompressed data) when using DISTINCT. The minimum value is 0.
distinct_overflow_mode	enum OverflowMode throw—abort query execution, return an error. break—stop query execution, return partial result.
max_rows_to_transfer	google.protobuf.Int64Value Limits the maximum number of rows that can be passed to a remote server or saved in a temporary table when using GLOBAL IN. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
max_bytes_to_transfer	google.protobuf.Int64Value Limits the maximum number of bytes (uncompressed data) that can be passed to a remote server or saved in a temporary table when using GLOBAL IN. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
transfer_overflow_mode	enum OverflowMode throw—abort query execution, return an error. break—stop query execution, return partial result.
max_execution_time	google.protobuf.Int64Value Limits the maximum query execution time in milliseconds. At this moment, this limitation is not checked when passing one of the sorting stages, as well as merging and finalizing aggregation funictions. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
timeout_overflow_mode	enum OverflowMode throw—abort query execution, return an error. break—stop query execution, return partial result.
max_rows_in_set	google.protobuf.Int64Value Limit on the number of rows in the set resulting from the execution of the IN section. The minimum value is 0.
max_bytes_in_set	google.protobuf.Int64Value Limit on the number of bytes in the set resulting from the execution of the IN section. The minimum value is 0.
set_overflow_mode	enum OverflowMode Determine the behavior on exceeding max_rows_in_set or max_bytes_in_set limit. Possible values: OVERFLOW_MODE_THROW, OVERFLOW_MODE_BREAK.
max_rows_in_join	google.protobuf.Int64Value Limit on maximum size of the hash table for JOIN, in rows. The minimum value is 0.
max_bytes_in_join	google.protobuf.Int64Value Limit on maximum size of the hash table for JOIN, in bytes. The minimum value is 0.
join_overflow_mode	enum OverflowMode Determine the behavior on exceeding max_rows_in_join or max_bytes_in_join limit. Possible values: OVERFLOW_MODE_THROW, OVERFLOW_MODE_BREAK.
max_columns_to_read	google.protobuf.Int64Value Limits the maximum number of columns that can be read from a table in a single query. If the query requires to read more columns to complete, then it will be aborted. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
max_temporary_columns	google.protobuf.Int64Value Limits the maximum number of temporary columns that must be kept in RAM at the same time when running a query, including constant columns. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
max_temporary_non_const_columns	google.protobuf.Int64Value Limits the maximum number of temporary columns that must be kept in RAM at the same time when running a query, excluding constant columns. Minimal value and default value: 0, no limitation is set. The minimum value is 0.
max_query_size	google.protobuf.Int64Value (default: 262144). Value must be greater than 0.
max_ast_depth	google.protobuf.Int64Value query may result in more complex and deeper syntax tree, compared to the SELECT ... WHERE ... query, containing constraints and conditions, in the most cases. (default: 1000). Value must be greater than 0.
max_ast_elements	google.protobuf.Int64Value (default: 50000). Value must be greater than 0.
max_expanded_ast_elements	google.protobuf.Int64Value (default: 500000). Value must be greater than 0.
min_execution_speed	google.protobuf.Int64Value Minimal execution speed in rows per second. The minimum value is 0.
min_execution_speed_bytes	google.protobuf.Int64Value Minimal execution speed in bytes per second. The minimum value is 0.
count_distinct_implementation	enum CountDistinctImplementation Aggregate function to use for implementation of count(DISTINCT ...).
input_format_values_interpret_expressions	google.protobuf.BoolValue expression; therefore an INSERT query for this value will fail and no data will be inserted into a table. expression will be parsed as SQL function, interpreted, and the current date and time will be inserted into the table as a result. (SQL parser is enabled).
input_format_defaults_for_omitted_fields	google.protobuf.BoolValue queries. (replacing is enabled).
output_format_json_quote_64bit_integers	google.protobuf.BoolValue and Int64) will be quoted when written to JSON output in order to maintain compatibility with the most of the JavaScript engines. (quoting 64-bit integers is disabled).
output_format_json_quote_denormals	google.protobuf.BoolValue and -inf) in JSON output format. (special values do not present in output).
low_cardinality_allow_in_native_format	google.protobuf.BoolValue true (default)—yes, use. false—convert LowCardinality columns to regular columns when doing SELECT, and convert regular columns to LowCardinality when doing INSERT. (LowCardinality columns are used in Native format).
empty_result_for_aggregation_by_empty_set	google.protobuf.BoolValue operation absent) on empty set (e.g., SELECT count(*) FROM table WHERE 0). true—ClickHouse will return an empty result for such queries. false (default)—ClickHouse will return a single-line result consisting of NULL values for aggregation functions, in accordance with SQL standard.
joined_subquery_requires_alias	google.protobuf.BoolValue
join_use_nulls	google.protobuf.BoolValue
transform_null_in	google.protobuf.BoolValue
http_connection_timeout	google.protobuf.Int64Value (default: 1000, 1 second).
http_receive_timeout	google.protobuf.Int64Value (default: 1800000, 1800 seconds, 30 minutes).
http_send_timeout	google.protobuf.Int64Value (default: 1800000, 1800 seconds, 30 minutes).
enable_http_compression	google.protobuf.BoolValue HTTP header in a HTTP request to force compression of HTTP response from ClickHouse. and deflate. (compression is disabled).
send_progress_in_http_headers	google.protobuf.BoolValue HTTP header. (notifications disabled).
http_headers_progress_interval	google.protobuf.Int64Value HTTP header, in milliseconds. (default: 100).
add_http_cors_header	google.protobuf.BoolValue (header is not added).
quota_mode	enum QuotaMode Quota accounting mode. Possible values: QUOTA_MODE_DEFAULT, QUOTA_MODE_KEYED and QUOTA_MODE_KEYED_BY_IP.

UserQuota

Field	Description
interval_duration	google.protobuf.Int64Value Duration of interval for quota in milliseconds. Minimal value is 1 second. The minimum value is 1000.
queries	google.protobuf.Int64Value The total number of queries. 0 - unlimited. The minimum value is 0.
errors	google.protobuf.Int64Value The number of queries that threw exception. 0 - unlimited. The minimum value is 0.
result_rows	google.protobuf.Int64Value The total number of rows given as the result.. 0 - unlimited. The minimum value is 0.
read_rows	google.protobuf.Int64Value The total number of source rows read from tables for running the query, on all remote servers. 0 - unlimited. The minimum value is 0.
execution_time	google.protobuf.Int64Value The total query execution time, in milliseconds (wall time). 0 - unlimited. The minimum value is 0.

HostSpec

Field	Description
zone_id	string ID of the availability zone where the host resides. To get a list of available zones, use the yandex.cloud.compute.v1.ZoneService.List request. The maximum string length in characters is 50.
type	Host.Type Required. Type of the host to be deployed.
subnet_id	string ID of the subnet that the host should belong to. This subnet should be a part of the network that the cluster belongs to. The ID of the network is set in the Cluster.network_id field. The maximum string length in characters is 50.
assign_public_ip	bool false — don't assign a public IP to the host. true — the host should have a public IP address.
shard_name	string Name of the shard that the host is assigned to. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<CreateClusterMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Cluster> if operation finished successfully.

CreateClusterMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster that is being created.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

Update

Updates the specified ClickHouse cluster.

rpc Update (UpdateClusterRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:UpdateClusterMetadata

    Operation.response:Cluster

UpdateClusterRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse Cluster resource to update. To get the ClickHouse cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
update_mask	google.protobuf.FieldMask Field mask that specifies which fields of the ClickHouse Cluster resource should be updated.
description	string New description of the ClickHouse cluster. The maximum string length in characters is 256.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource. For example, "project": "mvp" or "source": "dictionary". The new set of labels will completely replace the old ones. To add a label, request the current set with the ClusterService.Get method, then send an ClusterService.Update request with the new label added to the set. No more than 64 per resource. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]*. The maximum string length in characters for each key is 63. Each key must match the regular expression [a-z][-_0-9a-z]*.
config_spec	ConfigSpec New configuration and resources for hosts in the cluster.
name	string New name for the cluster. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
security_group_ids[]	string User security groups

ConfigSpec

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resources for a ClickHouse server.
zookeeper	Zookeeper Configuration and resources for a ZooKeeper server.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services. If you want a specific service to access the ClickHouse cluster, then set the necessary values in this policy.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.
admin_password	string Password for user 'admin' that has SQL user management access.

Clickhouse

Field	Description
config	config.ClickhouseConfig Configuration for a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts. If not set, minimal available resources will be used. All available resource presets can be retrieved with a ResourcePresetService.List request.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<UpdateClusterMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Cluster> if operation finished successfully.

UpdateClusterMetadata

Field	Description
cluster_id	string ID of the ClickHouse Cluster resource that is being updated.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

Delete

Deletes the specified ClickHouse cluster.

rpc Delete (DeleteClusterRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:DeleteClusterMetadata

    Operation.response:google.protobuf.Empty

DeleteClusterRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to delete. To get the ClickHouse cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<DeleteClusterMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<google.protobuf.Empty> if operation finished successfully.

DeleteClusterMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster that is being deleted.

Start

Starts the specified ClickHouse cluster.

rpc Start (StartClusterRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:StartClusterMetadata

    Operation.response:Cluster

StartClusterRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to start. The maximum string length in characters is 50.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<StartClusterMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Cluster> if operation finished successfully.

StartClusterMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster being started.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

Stop

Stops the specified ClickHouse cluster.

rpc Stop (StopClusterRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:StopClusterMetadata

    Operation.response:Cluster

StopClusterRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to stop. The maximum string length in characters is 50.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<StopClusterMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Cluster> if operation finished successfully.

StopClusterMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster being stopped.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

Move

Moves a ClickHouse cluster to the specified folder.

rpc Move (MoveClusterRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:MoveClusterMetadata

    Operation.response:Cluster

MoveClusterRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to move. The maximum string length in characters is 50.
destination_folder_id	string Required. ID of the destination folder. The maximum string length in characters is 50.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<MoveClusterMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Cluster> if operation finished successfully.

MoveClusterMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster being moved.
source_folder_id	string ID of the source folder.
destination_folder_id	string ID of the destination folder.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

AddZookeeper

Adds a ZooKeeper subcluster to the specified ClickHouse cluster.

rpc AddZookeeper (AddClusterZookeeperRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:AddClusterZookeeperMetadata

    Operation.response:Cluster

AddClusterZookeeperRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to modify. The maximum string length in characters is 50.
resources	Resources Resources allocated to Zookeeper hosts.
host_specs[]	HostSpec Configuration of ZooKeeper hosts.

Resources

Field	Description
resource_preset_id	string ID of the preset for computational resources available to a host (CPU, memory etc.). All available presets are listed in the documentation
disk_size	int64 Volume of the storage available to a host, in bytes.
disk_type_id	string network-hdd — network HDD drive, network-ssd — network SSD drive, local-ssd — local SSD storage.

HostSpec

Field	Description
zone_id	string ID of the availability zone where the host resides. To get a list of available zones, use the yandex.cloud.compute.v1.ZoneService.List request. The maximum string length in characters is 50.
type	Host.Type Required. Type of the host to be deployed.
subnet_id	string ID of the subnet that the host should belong to. This subnet should be a part of the network that the cluster belongs to. The ID of the network is set in the Cluster.network_id field. The maximum string length in characters is 50.
assign_public_ip	bool false — don't assign a public IP to the host. true — the host should have a public IP address.
shard_name	string Name of the shard that the host is assigned to. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<AddClusterZookeeperMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Cluster> if operation finished successfully.

AddClusterZookeeperMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

Backup

Creates a backup for the specified ClickHouse cluster.

rpc Backup (BackupClusterRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:BackupClusterMetadata

    Operation.response:Cluster

BackupClusterRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to back up. To get the ClickHouse cluster ID use a ClusterService.List request. The maximum string length in characters is 50.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<BackupClusterMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Cluster> if operation finished successfully.

BackupClusterMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster that is being backed up.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

Restore

Creates a new ClickHouse cluster using the specified backup.

rpc Restore (RestoreClusterRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:RestoreClusterMetadata

    Operation.response:Cluster

RestoreClusterRequest

Field	Description
backup_id	string Required. ID of the backup to create a cluster from. To get the backup ID, use a ClusterService.ListBackups request.
name	string Required. Name of the new ClickHouse cluster. The name must be unique within the folder. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.
description	string Description of the new ClickHouse cluster. The maximum string length in characters is 256.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource. For example, "project": "mvp" or "source": "dictionary". No more than 64 per resource. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]*. The maximum string length in characters for each key is 63. Each key must match the regular expression [a-z][-_0-9a-z]*.
environment	Cluster.Environment Required. Deployment environment of the new ClickHouse cluster.
config_spec	ConfigSpec Required. Configuration for the ClickHouse cluster to be created.
host_specs[]	HostSpec Configurations for ClickHouse hosts that should be created for the cluster that is being created from the backup. The number of elements must be greater than 0.
network_id	string Required. ID of the network to create the ClickHouse cluster in. The maximum string length in characters is 50.
folder_id	string ID of the folder to create the ClickHouse cluster in. The maximum string length in characters is 50.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
security_group_ids[]	string User security groups

ConfigSpec

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resources for a ClickHouse server.
zookeeper	Zookeeper Configuration and resources for a ZooKeeper server.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services. If you want a specific service to access the ClickHouse cluster, then set the necessary values in this policy.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.
admin_password	string Password for user 'admin' that has SQL user management access.

Clickhouse

Field	Description
config	config.ClickhouseConfig Configuration for a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts. If not set, minimal available resources will be used. All available resource presets can be retrieved with a ResourcePresetService.List request.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

HostSpec

Field	Description
zone_id	string ID of the availability zone where the host resides. To get a list of available zones, use the yandex.cloud.compute.v1.ZoneService.List request. The maximum string length in characters is 50.
type	Host.Type Required. Type of the host to be deployed.
subnet_id	string ID of the subnet that the host should belong to. This subnet should be a part of the network that the cluster belongs to. The ID of the network is set in the Cluster.network_id field. The maximum string length in characters is 50.
assign_public_ip	bool false — don't assign a public IP to the host. true — the host should have a public IP address.
shard_name	string Name of the shard that the host is assigned to. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<RestoreClusterMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Cluster> if operation finished successfully.

RestoreClusterMetadata

Field	Description
cluster_id	string ID of the new ClickHouse cluster that is being created from a backup.
backup_id	string ID of the backup that is being used for creating a cluster.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

RescheduleMaintenance

Reschedule planned maintenance operation.

rpc RescheduleMaintenance (RescheduleMaintenanceRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:RescheduleMaintenanceMetadata

    Operation.response:Cluster

RescheduleMaintenanceRequest

Field	Description
cluster_id	string Required. Required. ID of the ClickHouse cluster to maintenance reschedule. The maximum string length in characters is 50.
reschedule_type	enum RescheduleType Required. Required. The type of reschedule request.
delayed_until	google.protobuf.Timestamp The time for SPECIFIC_TIME reschedule. Limited by two weeks since first time scheduled.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<RescheduleMaintenanceMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Cluster> if operation finished successfully.

RescheduleMaintenanceMetadata

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster.
delayed_until	google.protobuf.Timestamp Required. New time of the planned maintenance. Can be in the past for rescheduled to "IMMEDIATE".

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

ListLogs

Retrieves logs for the specified ClickHouse cluster.

rpc ListLogs (ListClusterLogsRequest) returns (ListClusterLogsResponse)

ListClusterLogsRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to request logs for. To get the ClickHouse cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
column_filter[]	string Columns from logs table to request. If no columns are specified, entire log records are returned.
service_type	enum ServiceType Type of the service to request logs about. CLICKHOUSE: Logs of ClickHouse activity.
from_time	google.protobuf.Timestamp Start timestamp for the logs request, in RFC3339 text format.
to_time	google.protobuf.Timestamp End timestamp for the logs request, in RFC3339 text format.
page_size	int64 The maximum number of results per page to return. If the number of available results is larger than page_size, the service returns a ListClusterLogsResponse.next_page_token that can be used to get the next page of results in subsequent list requests. The maximum value is 1000.
page_token	string Page token. To get the next page of results, set page_token to the ListClusterLogsResponse.next_page_token returned by a previous list request. The maximum string length in characters is 100.

ListClusterLogsResponse

Field	Description
logs[]	LogRecord Requested log records.
next_page_token	string This token allows you to get the next page of results for list requests. If the number of results is larger than ListClusterLogsRequest.page_size, use the next_page_token as the value for the ListClusterLogsRequest.page_token query parameter in the next list request. Each subsequent list request will have its own next_page_token to continue paging through the results. This value is interchangeable with the StreamLogRecord.next_record_token from StreamLogs method.

LogRecord

Field	Description
timestamp	google.protobuf.Timestamp Log record timestamp in RFC3339 text format.
message	map<string,string> Contents of the log record.

StreamLogs

Same as ListLogs but using server-side streaming. Also allows for tail -f semantics.

rpc StreamLogs (StreamClusterLogsRequest) returns (stream StreamLogRecord)

StreamClusterLogsRequest

Field	Description
cluster_id	string Required. Required. ID of the ClickHouse cluster. The maximum string length in characters is 50.
column_filter[]	string Columns from logs table to get in the response.
service_type	enum ServiceType CLICKHOUSE: Logs of ClickHouse activity.
from_time	google.protobuf.Timestamp Start timestamp for the logs request.
to_time	google.protobuf.Timestamp End timestamp for the logs request. If this field is not set, all existing logs will be sent and then the new ones as they appear. In essence it has tail -f semantics.
record_token	string Record token. Set record_token to the StreamLogRecord.next_record_token returned by a previous StreamLogs request to start streaming from next log record. The maximum string length in characters is 100.
filter	string The field name. Currently filtering can be applied to the LogRecord.logs.message.hostname, LogRecord.logs.message.severity fields. A conditional operator. Can be either = or != for single values, IN or NOT IN for lists of values. The value. Must be 1-63 characters long and match the regular expression ^[a-z0-9.-]{1,61}$. The maximum string length in characters is 1000.

StreamLogRecord

Field	Description
record	LogRecord One of the requested log records.
next_record_token	string This token allows you to continue streaming logs starting from the exact same record. To continue streaming, specify value of [next_record_token [as value for the [StreamClusterLogsRequest.record_token] parameter in the next StreamLogs request. This value is interchangeable with the ListClusterLogsResponse.next_page_token from ListLogs method.

LogRecord

Field	Description
timestamp	google.protobuf.Timestamp Log record timestamp in RFC3339 text format.
message	map<string,string> Contents of the log record.

ListOperations

Retrieves the list of Operation resources for the specified cluster.

rpc ListOperations (ListClusterOperationsRequest) returns (ListClusterOperationsResponse)

ListClusterOperationsRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse Cluster resource to list operations for. The maximum string length in characters is 50.
page_size	int64 The maximum number of results per page to return. If the number of available results is larger than page_size, the service returns a ListClusterOperationsResponse.next_page_token that can be used to get the next page of results in subsequent list requests. The maximum value is 1000.
page_token	string Page token. To get the next page of results, set page_token to the ListClusterOperationsResponse.next_page_token returned by a previous list request. The maximum string length in characters is 100.

ListClusterOperationsResponse

Field	Description
operations[]	operation.Operation List of Operation resources for the specified ClickHouse cluster.
next_page_token	string This token allows you to get the next page of results for list requests. If the number of results is larger than ListClusterOperationsRequest.page_size, use the next_page_token as the value for the ListClusterOperationsRequest.page_token query parameter in the next list request. Each subsequent list request will have its own next_page_token to continue paging through the results.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any The normal response of the operation in case of success. If the original method returns no data on success, such as Delete, the response is google.protobuf.Empty. If the original method is the standard Create/Update, the response should be the target resource of the operation. Any method that returns a long-running operation should document the response type, if any.

ListBackups

Retrieves the list of available backups for the specified ClickHouse cluster.

rpc ListBackups (ListClusterBackupsRequest) returns (ListClusterBackupsResponse)

ListClusterBackupsRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster. To get the ClickHouse cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
page_size	int64 The maximum number of results per page to return. If the number of available results is larger than page_size, the service returns a ListClusterBackupsResponse.next_page_token that can be used to get the next page of results in subsequent list requests. The maximum value is 1000.
page_token	string Page token. To get the next page of results, set page_token to the ListClusterBackupsResponse.next_page_token returned by a previous list request. The maximum string length in characters is 100.

ListClusterBackupsResponse

Field	Description
backups[]	Backup List of ClickHouse Backup resources.
next_page_token	string This token allows you to get the next page of results for list requests. If the number of results is larger than ListClusterBackupsRequest.page_size, use the next_page_token as the value for the ListClusterBackupsRequest.page_token query parameter in the next list request. Each subsequent list request will have its own next_page_token to continue paging through the results.

Backup

Field	Description
id	string ID of the backup.
folder_id	string ID of the folder that the backup belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format (i.e. when the backup operation was completed).
source_cluster_id	string ID of the ClickHouse cluster that the backup was created for.
source_shard_names[]	string Names of the shards included in the backup.
started_at	google.protobuf.Timestamp Time when the backup operation was started.

ListHosts

Retrieves a list of hosts for the specified cluster.

rpc ListHosts (ListClusterHostsRequest) returns (ListClusterHostsResponse)

ListClusterHostsRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster. To get the ClickHouse cluster ID use a ClusterService.List request. The maximum string length in characters is 50.
page_size	int64 The maximum number of results per page to return. If the number of available results is larger than page_size, the service returns a ListClusterHostsResponse.next_page_token that can be used to get the next page of results in subsequent list requests. The maximum value is 1000.
page_token	string Page token. To get the next page of results, set page_token to the ListClusterHostsResponse.next_page_token returned by a previous list request. The maximum string length in characters is 100.

ListClusterHostsResponse

Field	Description
hosts[]	Host Requested list of hosts for the cluster.
next_page_token	string This token allows you to get the next page of results for list requests. If the number of results is larger than ListClusterHostsRequest.page_size, use the next_page_token as the value for the ListClusterHostsRequest.page_token query parameter in the next list request. Each subsequent list request will have its own next_page_token to continue paging through the results.

Host

Field	Description
name	string Name of the ClickHouse host. The host name is assigned by MDB at creation time, and cannot be changed. 1-63 characters long. The name is unique across all existing MDB hosts in Yandex.Cloud, as it defines the FQDN of the host.
cluster_id	string ID of the ClickHouse host. The ID is assigned by MDB at creation time.
zone_id	string ID of the availability zone where the ClickHouse host resides.
type	enum Type Type of the host. CLICKHOUSE: ClickHouse host. ZOOKEEPER: ZooKeeper host.
resources	Resources Resources allocated to the ClickHouse host.
health	enum Health Status code of the aggregated health of the host. UNKNOWN: Health of the host is unknown. ALIVE: The host is performing all its functions normally. DEAD: The host is inoperable, and cannot perform any of its essential functions. DEGRADED: The host is degraded, and can perform only some of its essential functions.
services[]	Service Services provided by the host.
subnet_id	string ID of the subnet that the host belongs to.
assign_public_ip	bool Flag showing public IP assignment status to this host.
shard_name	string

Resources

Field	Description
resource_preset_id	string ID of the preset for computational resources available to a host (CPU, memory etc.). All available presets are listed in the documentation
disk_size	int64 Volume of the storage available to a host, in bytes.
disk_type_id	string network-hdd — network HDD drive, network-ssd — network SSD drive, local-ssd — local SSD storage.

Service

Field	Description
type	enum Type Type of the service provided by the host. CLICKHOUSE: The host is a ClickHouse server. ZOOKEEPER: The host is a ZooKeeper server.
health	enum Health Status code of server availability. UNKNOWN: Health of the server is unknown. ALIVE: The server is working normally. DEAD: The server is dead or unresponsive.

AddHosts

Creates new hosts for a cluster.

rpc AddHosts (AddClusterHostsRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:AddClusterHostsMetadata

    Operation.response:google.protobuf.Empty

AddClusterHostsRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to add hosts to. To get the ClickHouse cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
host_specs[]	HostSpec Configurations for ClickHouse hosts that should be added to the cluster. The number of elements must be greater than 0.
copy_schema	google.protobuf.BoolValue Whether to copy schema to new ClickHouse hosts from replicas.

HostSpec

Field	Description
zone_id	string ID of the availability zone where the host resides. To get a list of available zones, use the yandex.cloud.compute.v1.ZoneService.List request. The maximum string length in characters is 50.
type	Host.Type Required. Type of the host to be deployed.
subnet_id	string ID of the subnet that the host should belong to. This subnet should be a part of the network that the cluster belongs to. The ID of the network is set in the Cluster.network_id field. The maximum string length in characters is 50.
assign_public_ip	bool false — don't assign a public IP to the host. true — the host should have a public IP address.
shard_name	string Name of the shard that the host is assigned to. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<AddClusterHostsMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<google.protobuf.Empty> if operation finished successfully.

AddClusterHostsMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster to which the hosts are being added.
host_names[]	string Names of hosts that are being added to the cluster.

DeleteHosts

Deletes the specified hosts for a cluster.

rpc DeleteHosts (DeleteClusterHostsRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:DeleteClusterHostsMetadata

    Operation.response:google.protobuf.Empty

DeleteClusterHostsRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to remove hosts from. To get the ClickHouse cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
host_names[]	string Names of hosts to delete. The number of elements must be greater than 0. The maximum string length in characters for each value is 253.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<DeleteClusterHostsMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<google.protobuf.Empty> if operation finished successfully.

DeleteClusterHostsMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster to remove hosts from.
host_names[]	string Names of hosts that are being deleted.

GetShard

Returns the specified shard.

rpc GetShard (GetClusterShardRequest) returns (Shard)

GetClusterShardRequest

Field	Description
cluster_id	string Required. ID of the cluster that the shard belongs to. To get the cluster ID, use a ClusterService.List(#List) request. To get the name of the database, use a [ClusterService.List] request. The maximum string length in characters is 50.
shard_name	string Required. Name of the shard to request information about. To get the name of a shard, use a ClusterService.ListShards request. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

Shard

Field	Description
name	string Name of the shard.
cluster_id	string ID of the cluster that the shard belongs to.
config	ShardConfig Configuration of the shard.

ShardConfig

Field	Description
clickhouse	Clickhouse ClickHouse configuration for a shard.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet ClickHouse settings for a shard.
resources	Resources Computational resources for a shard.
weight	google.protobuf.Int64Value Relative weight of a shard considered when writing data to the cluster. For details, see ClickHouse documentation.

ListShards

Retrieves a list of shards that belong to the specified cluster.

rpc ListShards (ListClusterShardsRequest) returns (ListClusterShardsResponse)

ListClusterShardsRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to list shards in. To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
page_size	int64 The maximum number of results per page to return. If the number of available results is larger than page_size, the service returns a ListClusterShardsResponse.next_page_token that can be used to get the next page of results in subsequent list requests. Acceptable values are 0 to 1000, inclusive.
page_token	string Page token. to get the next page of results, set page_token to the ListClusterShardsResponse.next_page_token returned by a previous list request. The maximum string length in characters is 100.

ListClusterShardsResponse

Field	Description
shards[]	Shard List of ClickHouse shards.
next_page_token	string This token allows you to get the next page of results for list requests. If the number of results is larger than ListClusterShardsRequest.page_size, use the next_page_token as the value for the ListClusterShardsRequest.page_token parameter in the next list request. Each subsequent list request will have its own next_page_token to continue paging through the results.

Shard

Field	Description
name	string Name of the shard.
cluster_id	string ID of the cluster that the shard belongs to.
config	ShardConfig Configuration of the shard.

ShardConfig

Field	Description
clickhouse	Clickhouse ClickHouse configuration for a shard.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet ClickHouse settings for a shard.
resources	Resources Computational resources for a shard.
weight	google.protobuf.Int64Value Relative weight of a shard considered when writing data to the cluster. For details, see ClickHouse documentation.

AddShard

Creates a new shard in the specified cluster.

rpc AddShard (AddClusterShardRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:AddClusterShardMetadata

    Operation.response:Shard

AddClusterShardRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to add a shard to. To get the ClickHouse cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
shard_name	string Required. Name for the new shard. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.
config_spec	ShardConfigSpec Configuration of the new shard.
host_specs[]	HostSpec Configurations for ClickHouse hosts that should be created with the shard. The number of elements must be greater than 0.
copy_schema	google.protobuf.BoolValue Whether to copy schema to hosts of the shard to be created. The schema is copied from hosts of an existing shard.

ShardConfigSpec

Field	Description
clickhouse	Clickhouse ClickHouse configuration for a shard.

Clickhouse

Field	Description
config	config.ClickhouseConfig ClickHouse settings for the shard.
resources	Resources Computational resources for the shard.
weight	google.protobuf.Int64Value Relative weight of the shard considered when writing data to the cluster. For details, see ClickHouse documentation.

HostSpec

Field	Description
zone_id	string ID of the availability zone where the host resides. To get a list of available zones, use the yandex.cloud.compute.v1.ZoneService.List request. The maximum string length in characters is 50.
type	Host.Type Required. Type of the host to be deployed.
subnet_id	string ID of the subnet that the host should belong to. This subnet should be a part of the network that the cluster belongs to. The ID of the network is set in the Cluster.network_id field. The maximum string length in characters is 50.
assign_public_ip	bool false — don't assign a public IP to the host. true — the host should have a public IP address.
shard_name	string Name of the shard that the host is assigned to. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<AddClusterShardMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Shard> if operation finished successfully.

AddClusterShardMetadata

Field	Description
cluster_id	string ID of the cluster that a shard is being added to.
shard_name	string Name of the shard being created.

Shard

Field	Description
name	string Name of the shard.
cluster_id	string ID of the cluster that the shard belongs to.
config	ShardConfig Configuration of the shard.

ShardConfig

Field	Description
clickhouse	Clickhouse ClickHouse configuration for a shard.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet ClickHouse settings for a shard.
resources	Resources Computational resources for a shard.
weight	google.protobuf.Int64Value Relative weight of a shard considered when writing data to the cluster. For details, see ClickHouse documentation.

UpdateShard

Modifies the specified shard.

rpc UpdateShard (UpdateClusterShardRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:UpdateClusterShardMetadata

    Operation.response:Shard

UpdateClusterShardRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster the shard belongs to. To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
shard_name	string Required. Name of the shard to be updated. To get the name of a shard, use a ClusterService.ListShards request. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.
update_mask	google.protobuf.FieldMask Field mask that specifies which attributes of the ClickHouse shard should be updated.
config_spec	ShardConfigSpec New configuration for the specified shard.

ShardConfigSpec

Field	Description
clickhouse	Clickhouse ClickHouse configuration for a shard.

Clickhouse

Field	Description
config	config.ClickhouseConfig ClickHouse settings for the shard.
resources	Resources Computational resources for the shard.
weight	google.protobuf.Int64Value Relative weight of the shard considered when writing data to the cluster. For details, see ClickHouse documentation.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<UpdateClusterShardMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Shard> if operation finished successfully.

UpdateClusterShardMetadata

Field	Description
cluster_id	string ID of the cluster that contains the shard being updated.
shard_name	string Name of the shard being updated.

Shard

Field	Description
name	string Name of the shard.
cluster_id	string ID of the cluster that the shard belongs to.
config	ShardConfig Configuration of the shard.

ShardConfig

Field	Description
clickhouse	Clickhouse ClickHouse configuration for a shard.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet ClickHouse settings for a shard.
resources	Resources Computational resources for a shard.
weight	google.protobuf.Int64Value Relative weight of a shard considered when writing data to the cluster. For details, see ClickHouse documentation.

DeleteShard

Deletes the specified shard.

rpc DeleteShard (DeleteClusterShardRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:DeleteClusterShardMetadata

    Operation.response:google.protobuf.Empty

DeleteClusterShardRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster the shard belongs to. To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
shard_name	string Required. Name of the shard to be deleted. To get the name of a shard, use a ClusterService.ListShards request. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<DeleteClusterShardMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<google.protobuf.Empty> if operation finished successfully.

DeleteClusterShardMetadata

Field	Description
cluster_id	string ID of the cluster that contains the shard being deleted.
shard_name	string Name of the shard being deleted.

GetShardGroup

Returns the specified shard group.

rpc GetShardGroup (GetClusterShardGroupRequest) returns (ShardGroup)

GetClusterShardGroupRequest

Field	Description
cluster_id	string Required. ID of the cluster that the shard group belongs to. The maximum string length in characters is 50.
shard_group_name	string Required. Name of the shard group to request information about. To get the name of a shard group, use a ClusterService.ListShardGroups request. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

ShardGroup

Field	Description
name	string Name of the shard group
cluster_id	string ID of the cluster that the shard belongs to.
description	string Description of the ClickHouse cluster shard group. 0-256 characters long.
shard_names[]	string List of shard names contained in shard group

ListShardGroups

Retrieves a list of shard groups that belong to specified cluster.

rpc ListShardGroups (ListClusterShardGroupsRequest) returns (ListClusterShardGroupsResponse)

ListClusterShardGroupsRequest

Field	Description
cluster_id	string Required. ID of the cluster that the shard group belongs to. The maximum string length in characters is 50.
page_size	int64 The maximum number of results per page to return. If the number of available results is larger than page_size, the service returns a ListClusterShardGroupsResponse.next_page_token that can be used to get the next page of results in subsequent list requests. Acceptable values are 0 to 1000, inclusive.
page_token	string Page token. To get the next page of results, set page_token to the ListClusterShardGroupsResponse.next_page_token returned by a previous list request. The maximum string length in characters is 100.

ListClusterShardGroupsResponse

Field	Description
shard_groups[]	ShardGroup List of ClickHouse Cluster shard groups.
next_page_token	string This token allows you to get the next page of results for list requests. If the number of results is larger than ListClusterShardGroupsRequest.page_size, use the next_page_token as the value for the ListClusterShardGroupsRequest.page_token parameter in the next list request. Each subsequent list request will have its own next_page_token to continue paging through the results.

ShardGroup

Field	Description
name	string Name of the shard group
cluster_id	string ID of the cluster that the shard belongs to.
description	string Description of the ClickHouse cluster shard group. 0-256 characters long.
shard_names[]	string List of shard names contained in shard group

CreateShardGroup

Creates a new shard group in the specified cluster.

rpc CreateShardGroup (CreateClusterShardGroupRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:CreateClusterShardGroupMetadata

    Operation.response:ShardGroup

CreateClusterShardGroupRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to add a shard group to. To get the ClickHouse cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
shard_group_name	string Required. Name for the new shard group. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.
description	string Description of the ClickHouse cluster shard group. 0-256 characters long.
shard_names[]	string List of shard names that belongs to the new group.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<CreateClusterShardGroupMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<ShardGroup> if operation finished successfully.

CreateClusterShardGroupMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster to add a shard group to.
shard_group_name	string Name for the new shard group.

ShardGroup

Field	Description
name	string Name of the shard group
cluster_id	string ID of the cluster that the shard belongs to.
description	string Description of the ClickHouse cluster shard group. 0-256 characters long.
shard_names[]	string List of shard names contained in shard group

UpdateShardGroup

Modifies the specified shard group.

rpc UpdateShardGroup (UpdateClusterShardGroupRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:UpdateClusterShardGroupMetadata

    Operation.response:ShardGroup

UpdateClusterShardGroupRequest

Field	Description
cluster_id	string Required. ID of the cluster that contains the shard group being updated. The maximum string length in characters is 50.
shard_group_name	string Required. Name of the shard group that should be updated. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.
update_mask	google.protobuf.FieldMask Field mask that specifies which attributes of the ClickHouse shard group should be updated.
description	string Description of the ClickHouse cluster shard group. 0-256 characters long.
shard_names[]	string Updated list of shard names that belongs to the new group.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<UpdateClusterShardGroupMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<ShardGroup> if operation finished successfully.

UpdateClusterShardGroupMetadata

Field	Description
cluster_id	string ID of the cluster that contains the shard group being updated.
shard_group_name	string Name of the shard group that should be updated.

ShardGroup

Field	Description
name	string Name of the shard group
cluster_id	string ID of the cluster that the shard belongs to.
description	string Description of the ClickHouse cluster shard group. 0-256 characters long.
shard_names[]	string List of shard names contained in shard group

DeleteShardGroup

Deletes the specified shard group.

rpc DeleteShardGroup (DeleteClusterShardGroupRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:DeleteClusterShardGroupMetadata

    Operation.response:google.protobuf.Empty

DeleteClusterShardGroupRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster the shard group belongs to. The maximum string length in characters is 50.
shard_group_name	string Required. Name of the shard group that should be deleted. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<DeleteClusterShardGroupMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<google.protobuf.Empty> if operation finished successfully.

DeleteClusterShardGroupMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster the shard group belongs to.
shard_group_name	string Name of the shard group that should be deleted.

CreateExternalDictionary

Creates an external dictionary for the specified ClickHouse cluster.

rpc CreateExternalDictionary (CreateClusterExternalDictionaryRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:CreateClusterExternalDictionaryMetadata

    Operation.response:Cluster

CreateClusterExternalDictionaryRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to create the external dictionary for. To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
external_dictionary	config.ClickhouseConfig.ExternalDictionary Configuration of the external dictionary.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<CreateClusterExternalDictionaryMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Cluster> if operation finished successfully.

CreateClusterExternalDictionaryMetadata

Field	Description
cluster_id	string ID of the cluster for which an external dictionary is being created.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp

DeleteExternalDictionary

Deletes the specified external dictionary.

rpc DeleteExternalDictionary (DeleteClusterExternalDictionaryRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:DeleteClusterExternalDictionaryMetadata

    Operation.response:Cluster

DeleteClusterExternalDictionaryRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to delete the external dictionary from. To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
external_dictionary_name	string Name of the external dictionary to delete.

Operation

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
metadata	google.protobuf.Any<DeleteClusterExternalDictionaryMetadata> Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
result	oneof: error or response The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
error	google.rpc.Status The error result of the operation in case of failure or cancellation.
response	google.protobuf.Any<Cluster> if operation finished successfully.

DeleteClusterExternalDictionaryMetadata

Field	Description
cluster_id	string ID of the cluster where an external dictionary is being deleted.

Cluster

Field	Description
id	string ID of the ClickHouse cluster. This ID is assigned by MDB at creation time.
folder_id	string ID of the folder that the ClickHouse cluster belongs to.
created_at	google.protobuf.Timestamp Creation timestamp in RFC3339 text format.
name	string Name of the ClickHouse cluster. The name is unique within the folder. 1-63 characters long.
description	string Description of the ClickHouse cluster. 0-256 characters long.
labels	map<string,string> Custom labels for the ClickHouse cluster as key:value pairs. Maximum 64 per resource.
environment	enum Environment Deployment environment of the ClickHouse cluster. PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance. PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[]	Monitoring Description of monitoring systems relevant to the ClickHouse cluster.
config	ClusterConfig Configuration of the ClickHouse cluster.
network_id	string ID of the network that the cluster belongs to.
health	enum Health Aggregated cluster health. HEALTH_UNKNOWN: State of the cluster is unknown (Host.health for every host in the cluster is UNKNOWN). ALIVE: Cluster is alive and well (Host.health for every host in the cluster is ALIVE). DEAD: Cluster is inoperable (Host.health for every host in the cluster is DEAD). DEGRADED: Cluster is working below capacity (Host.health for at least one host in the cluster is not ALIVE).
status	enum Status Current state of the cluster. STATUS_UNKNOWN: Cluster state is unknown. CREATING: Cluster is being created. RUNNING: Cluster is running normally. ERROR: Cluster encountered a problem and cannot operate. UPDATING: Cluster is being updated. STOPPING: Cluster is stopping. STOPPED: Cluster stopped. STARTING: Cluster is starting.
service_account_id	string ID of the service account used for access to Yandex Object Storage.
maintenance_window	MaintenanceWindow Window of maintenance operations.
planned_operation	MaintenanceOperation Maintenance operation planned at nearest maintenance_window.
security_group_ids[]	string User security groups

Monitoring

Field	Description
name	string Name of the monitoring system.
description	string Description of the monitoring system.
link	string Link to the monitoring system charts for the ClickHouse cluster.

ClusterConfig

Field	Description
version	string Version of the ClickHouse server software.
clickhouse	Clickhouse Configuration and resource allocation for ClickHouse hosts.
zookeeper	Zookeeper Configuration and resource allocation for ZooKeeper hosts.
backup_window_start	google.type.TimeOfDay Time to start the daily backup, in the UTC timezone.
access	Access Access policy for external services.
cloud_storage	CloudStorage
sql_database_management	google.protobuf.BoolValue Whether database management through SQL commands is enabled.
sql_user_management	google.protobuf.BoolValue Whether user management through SQL commands is enabled.

Clickhouse

Field	Description
config	config.ClickhouseConfigSet Configuration settings of a ClickHouse server.
resources	Resources Resources allocated to ClickHouse hosts.

Zookeeper

Field	Description
resources	Resources Resources allocated to ZooKeeper hosts.

Access

Field	Description
data_lens	bool Allow to export data from the cluster to Yandex DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details.
metrika	bool Allow to import data from Yandex.Metrica and AppMetrica to the cluster. See Export data to Yandex.Cloud for more details.
serverless	bool Allow access to cluster for Serverless.

CloudStorage

Field	Description
enabled	bool Whether to use Yandex Object Storage for storing ClickHouse data.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window
anytime	AnytimeMaintenanceWindow
weekly_maintenance_window	WeeklyMaintenanceWindow

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay
hour	int64 Hour of the day in UTC. Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp