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	Reschedules 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.
UpdateHosts	Updates the specified hosts.
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	Updates the specified shard group.
DeleteShardGroup	Deletes the specified shard group.
CreateExternalDictionary	Creates an external dictionary for the specified ClickHouse cluster.
UpdateExternalDictionary	Updates 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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

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 the previous list request. The maximum string length in characters is 100.
filter	string A filter expression that filters resources listed in the response. The expression must specify: The field name. Currently you can only use filtering with the Cluster.name field. An = operator. The value in double quotes ("). Must 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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

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 Object Storage.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

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. If not set, it's granted permissions to access all databases.
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 Restricts permissions for non-DDL queries. To restrict permissions for DDL queries, use allow_ddl instead. 0 (default)-no restrictions. 1-only read data queries are allowed. 2-read data and change settings queries are allowed. See in-depth description in ClickHouse documentation. 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.
allow_introspection_functions	google.protobuf.BoolValue Enables introspections functions for query profiling. More info see in ClickHouse documentation.
connect_timeout	google.protobuf.Int64Value Connection timeout in milliseconds. Value must be greater than 0 (default: 10000, 10 seconds). Value must be greater than 0.
connect_timeout_with_failover	google.protobuf.Int64Value The timeout in milliseconds for connecting to a remote server for a Distributed table engine. Applies only if the cluster uses sharding and replication. If unsuccessful, several attempts are made to connect to various replicas. Default value: 50. More info see in ClickHouse documentation. Value must be greater than 0.
receive_timeout	google.protobuf.Int64Value Receive timeout in milliseconds. Value must be greater than 0 (default: 300000, 300 seconds or 5 minutes). Value must be greater than 0.
send_timeout	google.protobuf.Int64Value Send timeout in milliseconds. Value must be greater than 0 (default: 300000, 300 seconds or 5 minutes). Value must be greater than 0.
timeout_before_checking_execution_speed	google.protobuf.Int64Value Timeout (in seconds) between checks of execution speed. It is checked that execution speed is not less that specified in min_execution_speed parameter. Default value: 10.
insert_quorum	google.protobuf.Int64Value Enables or disables write quorum for ClickHouse cluster. If the value is less than 2, then write quorum is disabled, otherwise it is enabled. When used, write quorum guarantees that ClickHouse has written data to the quorum of insert_quorum replicas with no errors until the insert_quorum_timeout expires. All replicas in the quorum are in the consistent state, meaning that they contain linearized data from the previous INSERT queries. Employ write quorum, if you need the guarantees that the written data would not be lost in case of one or more replicas failure. You can use select_sequential_consistency setting to read the data written with write quorum. See in-depth description in ClickHouse documentation. The minimum value is 0.
insert_quorum_timeout	google.protobuf.Int64Value Quorum write timeout in milliseconds. If the write quorum is enabled in the cluster, this timeout expires and some data is not written to the insert_quorum replicas, then ClickHouse will abort the execution of INSERT query and return an error. In this case, the client must send the query again to write the data block into the same or another replica. Minimum value: 1000, 1 second (default: 60000, 1 minute). The minimum value is 1000.
insert_quorum_parallel	google.protobuf.BoolValue See in-depth description in ClickHouse documentation.
insert_null_as_default	google.protobuf.BoolValue Enables the insertion of default values instead of NULL into columns with not nullable data type. Default value: true. More info see in ClickHouse documentation.
select_sequential_consistency	google.protobuf.BoolValue Determines the behavior of SELECT 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. Default value: false (sequential consistency is disabled).
deduplicate_blocks_in_dependent_materialized_views	google.protobuf.BoolValue See in-depth description in ClickHouse documentation.
replication_alter_partitions_sync	google.protobuf.Int64Value Wait mode for asynchronous actions in ALTER queries on replicated tables: 0-do not wait for replicas. 1-only wait for own execution (default). 2-wait for all replicas. See in-depth description in ClickHouse documentation. Acceptable values are 0 to 2, inclusive.
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 Enables or disables query forcing to a stale replica in case the actual data is unavailable. If enabled, ClickHouse will choose the most up-to-date replica and force the query to use the data in this replica. This setting can be used when doing SELECT query from a distributed table that points to replicated tables. Default value: true (query forcing is enabled). See in-depth description in ClickHouse documentation.
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 Enables of disables memory saving mode when doing distributed aggregation. When ClickHouse works with a distributed query, external aggregation is done on remote servers. Enable this setting to achieve a smaller memory footprint on the server that sourced such a distributed query. Default value: false (memory saving mode is disabled). See in-depth description in ClickHouse documentation.
distributed_ddl_task_timeout	google.protobuf.Int64Value Timeout for DDL queries, in milliseconds.
skip_unavailable_shards	google.protobuf.BoolValue Enables or disables silent skipping of unavailable shards. A shard is considered unavailable if all its replicas are also unavailable. Default value: false (silent skipping is disabled). See in-depth description in ClickHouse documentation.
compile_expressions	google.protobuf.BoolValue Enables or disables expression compilation. If you execute a lot of queries that contain identical expressions, then enable this setting. As a result, such queries may be executed faster due to use of compiled expressions. Use this setting in combination with min_count_to_compile_expression setting. Default value: false (expression compilation is disabled).
min_count_to_compile_expression	google.protobuf.Int64Value How many identical expressions ClickHouse has to encounter before they are compiled. Minimum value: 0 (default: 3). For the 0 value compilation is synchronous: a query waits for expression compilation process to complete prior to continuing execution. It is recommended to set this value only for testing purposes. For all other values, compilation is asynchronous: the compilation process executes in a separate thread. When a compiled expression is ready, it will be used by ClickHouse for eligible queries, including the ones that are currently running. The minimum value is 0.
max_block_size	google.protobuf.Int64Value The maximum block size for reading. Data in ClickHouse is organized and processed by blocks (block is a set of columns' parts). The internal processing cycles for a single block are efficient enough, but there are noticeable expenditures on each block. This setting is a recommendation for size of block (in a count of rows) that should be loaded from tables. Value must be greater than 0 (default: 65536). See in-depth description in ClickHouse documentation. Value must be greater than 0.
min_insert_block_size_rows	google.protobuf.Int64Value Limits the minimum number of rows in a block to be inserted in a table by INSERT query. Blocks that are smaller than the specified value, will be squashed together into the bigger blocks. Minimal value: 0, block squashing is disabled (default: 1048576). The minimum value is 0.
min_insert_block_size_bytes	google.protobuf.Int64Value Limits the minimum number of bytes in a block to be inserted in a table by INSERT query. Blocks that are smaller than the specified value, will be squashed together into the bigger blocks. Minimal value: 0, block squashing is disabled (default: 268435456, 256 MB). The minimum value is 0.
max_insert_block_size	google.protobuf.Int64Value Allows to form blocks of the specified size (in bytes) when inserting data in a table. This setting has effect only if server is creating such blocks by itself. Value must be greater than 0 (default: 1048576). See in-depth description in ClickHouse documentation. 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 Determines whether to use the cache of uncompressed blocks, or not. Using this cache can significantly reduce latency and increase the throughput when a huge amount of small queries is to be processed. Enable this setting for the users who instantiates small queries frequently. This setting has effect only for tables of the MergeTree family. Default value: false (uncompressed cache is disabled). See in-depth description in ClickHouse documentation.
merge_tree_max_rows_to_use_cache	google.protobuf.Int64Value Limits the maximum size in rows of the request that can use the cache of uncompressed data. The cache is not used for requests larger than the specified value. Use this setting in combination with use_uncompressed_cache setting. Value must be greater than 0 (default: 128x8192). Value must be greater than 0.
merge_tree_max_bytes_to_use_cache	google.protobuf.Int64Value Limits the maximum size in bytes of the request that can use the cache of uncompressed data. The cache is not used for requests larger than the specified value. Use this setting in combination with use_uncompressed_cache setting. Value must be greater than 0 (default: 192x10x1024x1024). Value must be greater than 0.
merge_tree_min_rows_for_concurrent_read	google.protobuf.Int64Value Limits the minimum number of rows to be read from a file to enable concurrent read. If the number of rows to be read exceeds this value, then ClickHouse will try to use a few threads to read from a file concurrently. This setting has effect only for tables of the MergeTree family. Value must be greater than 0 (default: 20x8192). Value must be greater than 0.
merge_tree_min_bytes_for_concurrent_read	google.protobuf.Int64Value Limits the number of bytes to be read from a file to enable concurrent read. If the number of bytes to be read exceeds this value, then ClickHouse will try to use a few threads to read from a file concurrently. This setting has effect only for tables of the MergeTree family. Value must be greater than 0 (default: 24x10x1024x1024). Value must be greater than 0.
max_bytes_before_external_group_by	google.protobuf.Int64Value Sets the threshold of RAM consumption (in bytes) after that the temporary data, collected during the GROUP BY operation, should be flushed to disk to limit the RAM comsumption. By default, aggregation is done by employing hash table that resides in RAM. A query can result in aggregation of huge data volumes that can lead to memory exhaustion and abortion of the query (see the max_memory_usage setting). For such queries, you can use this setting to force ClickHouse to do flushing and complete aggregation successfully. Minimal value and default value: 0, GROUP BY in the external memory is disabled. When using aggregation in external memory, it is recommended to set the value of this setting twice as low as the max_memory_usage setting value (by default, the maximum memory usage is limited to ten gigabytes). See in-depth description in ClickHouse documentation. See also: the distributed_aggregation_memory_efficient setting.
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 Sets the priority of a query. 0-priority is not used. 1-the highest priority. and so on. The higher the number, the lower a query's priority. This setting should be set up for each query individually. If ClickHouse is working with the high-priority queries, and a low-priority query enters, then the low-priority query is paused until higher-priority queries are completed. Minimal value and default value: 0, priority is not used. The minimum value is 0.
max_threads	google.protobuf.Int64Value Limits the maximum number of threads to process the request (setting does not take threads that read data from remote servers into account). This setting applies to threads that perform the same stages of the query processing pipeline in parallel. Minimal value and default value: 0 (the thread number is calculated automatically based on the number of physical CPU cores, no HyperThreading cores are taken into account). See in-depth description in ClickHouse documentation. Value must be greater than 0.
max_memory_usage	google.protobuf.Int64Value Limits the maximum memory usage (in bytes) for processing of a single user's query 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 any user's single query on a single server. Minimal value: 0, no limitation is set. Value that is set in the ClickHouse default config file: 10737418240 (10 GB). If you use max_bytes_before_external_group_by or max_bytes_before_external_sort setting, then it is recommended to set their values twice as low as max_memory_usage setting value. See in-depth description in ClickHouse documentation. 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.
max_partitions_per_insert_block	google.protobuf.Int64Value See in-depth description in ClickHouse documentation.
max_concurrent_queries_for_user	google.protobuf.Int64Value The maximum number of concurrent requests per user. Default value: 0 (no limit).
force_index_by_date	google.protobuf.BoolValue If enabled, query is not executed if the ClickHouse can't use index by date. This setting has effect only for tables of the MergeTree family. Default value: false (setting is disabled, query executes even if ClickHouse can't use index by date). See in-depth description in ClickHouse documentation.
force_primary_key	google.protobuf.BoolValue If enabled, query is not executed if the ClickHouse can't use index by primary key. This setting has effect only for tables of the MergeTree family. Default value: false (setting is disabled, query executes even if ClickHouse can't use index by primary key). See in-depth description in ClickHouse documentation.
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 Determines the behavior on exceeding limits while reading the data. 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 Determines the behavior on exceeding limits while doing aggregation. 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 Determines the behavior on exceeding limits while sorting. 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 Determines the behavior on exceeding limits while forming result. 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 Determines the behavior on exceeding limits while doing DISCTINCT. 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 Determines the behavior on exceeding limits while doing transfers. 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 Determines the behavior on exceeding limits of execution time. 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.
join_algorithm[]	enum JoinAlgorithm See in-depth description in ClickHouse documentation.
any_join_distinct_right_table_keys	google.protobuf.BoolValue See in-depth description in ClickHouse documentation.
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 Limits the size of the part of a query that can be transferred to RAM for parsing with the SQL parser, in bytes. Value must be greater than 0 (default: 262144). See in-depth description in ClickHouse documentation. Value must be greater than 0.
max_ast_depth	google.protobuf.Int64Value Limits the maximum depth of query syntax tree. Executing a big and complex query may result in building a syntax tree of enormous depth. By using this setting, you can prohibit execution of over-sized or non-optimized queries for huge tables. For example, the **SELECT *** query may result in more complex and deeper syntax tree, compared to the SELECT ... WHERE ... query, containing constraints and conditions, in the most cases. A user can be forced to construct more optimized queries, if this setting is used. Value must be greater than 0 (default: 1000). If a too small value is set, it may render ClickHouse unable to execute even simple queries. See in-depth description in ClickHouse documentation. Value must be greater than 0.
max_ast_elements	google.protobuf.Int64Value Limits the maximum size of query syntax tree in number of nodes. Executing a big and complex query may result in building a syntax tree of enormous size. By using this setting, you can prohibit execution of over-sized or non-optimized queries for huge tables. Value must be greater than 0 (default: 50000). If a too small value is set, it may render ClickHouse unable to execute even simple queries. See in-depth description in ClickHouse documentation. Value must be greater than 0.
max_expanded_ast_elements	google.protobuf.Int64Value Limits the maximum size of query syntax tree in number of nodes after expansion of aliases and the asterisk values. Executing a big and complex query may result in building a syntax tree of enormous size. By using this setting, you can prohibit execution of over-sized or non-optimized queries for huge tables. Value must be greater than 0 (default: 500000). If a too small value is set, it may render ClickHouse unable to execute even simple queries. 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 Enables or disables SQL parser if the fast stream parser cannot parse the data. Enable this setting, if the data that you want to insert into a table contains SQL expressions. For example, the stream parser is unable to parse a value that contains now() expression; therefore an INSERT query for this value will fail and no data will be inserted into a table. With enabled SQL parser, this expression is parsed correctly: the now() expression will be parsed as SQL function, interpreted, and the current date and time will be inserted into the table as a result. This setting has effect only if you use Values format when inserting data. Default value: true (SQL parser is enabled). See in-depth description in ClickHouse documentation.
input_format_defaults_for_omitted_fields	google.protobuf.BoolValue Enables or disables replacing omitted input values with default values of the respective columns when performing INSERT queries. Default value: true (replacing is enabled).
input_format_null_as_default	google.protobuf.BoolValue See in-depth description in ClickHouse documentation.
date_time_input_format	enum DateTimeInputFormat See in-depth description in ClickHouse documentation.
input_format_with_names_use_header	google.protobuf.BoolValue See in-depth description in ClickHouse documentation.
output_format_json_quote_64bit_integers	google.protobuf.BoolValue Enables quoting of 64-bit integers in JSON output format. If this setting is enabled, then 64-bit integers (UInt64 and Int64) will be quoted when written to JSON output in order to maintain compatibility with the most of the JavaScript engines. Otherwise, such integers will not be quoted. Default value: false (quoting 64-bit integers is disabled).
output_format_json_quote_denormals	google.protobuf.BoolValue Enables special floating-point values (+nan, -nan, +inf and -inf) in JSON output format. Default value: false (special values do not present in output).
date_time_output_format	enum DateTimeOutputFormat See in-depth description in ClickHouse documentation.
low_cardinality_allow_in_native_format	google.protobuf.BoolValue Determines whether to use LowCardinality type in Native format. 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 (aka sparse columns) store data in more effective way, compared to regular columns, by using hash tables. If data to insert suits this storage format, ClickHouse will place them into LowCardinality column. If you use a third-party ClickHouse client that can't work with LowCardinality columns, then this client will not be able to correctly interpret the result of the query that asks for data stored in LowCardinality column. Disable this setting to convert LowCardinality column to regular column when creating the result, so such clients will be able to process the result. Official ClickHouse client works with LowCardinality columns out-of-the-box. Default value: true (LowCardinality columns are used in Native format).
allow_suspicious_low_cardinality_types	google.protobuf.BoolValue Allows specifying LowCardinality modifier for types of small fixed size (8 or less) in CREATE TABLE statements. Enabling this may increase merge times and memory consumption. More info see in ClickHouse documentation.
empty_result_for_aggregation_by_empty_set	google.protobuf.BoolValue Enables returning of empty result when aggregating without keys (with GROUP BY 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.
http_connection_timeout	google.protobuf.Int64Value HTTP connection timeout, in milliseconds. Value must be greater than 0 (default: 1000, 1 second).
http_receive_timeout	google.protobuf.Int64Value HTTP receive timeout, in milliseconds. Value must be greater than 0 (default: 1800000, 1800 seconds, 30 minutes).
http_send_timeout	google.protobuf.Int64Value HTTP send timeout, in milliseconds. Value must be greater than 0 (default: 1800000, 1800 seconds, 30 minutes).
enable_http_compression	google.protobuf.BoolValue Enables or disables data compression in HTTP responses. By default, ClickHouse stores data compressed. When executing a query, its result is uncompressed. Use this setting to command ClickHouse to compress the result when sending it via HTTP. Enable this setting and add the Accept-Encoding: HTTP header in a HTTP request to force compression of HTTP response from ClickHouse. ClickHouse support the following compression methods: gzip, br and deflate. Default value: false (compression is disabled). See in-depth description in ClickHouse documentation.
send_progress_in_http_headers	google.protobuf.BoolValue Enables progress notifications using X-ClickHouse-Progress HTTP header. Default value: false (notifications disabled).
http_headers_progress_interval	google.protobuf.Int64Value Minimum interval between progress notifications with X-ClickHouse-Progress HTTP header, in milliseconds. Value must be greater than 0 (default: 100).
add_http_cors_header	google.protobuf.BoolValue Adds CORS header in HTTP responses. Default value: false (header is not added).
cancel_http_readonly_queries_on_client_close	google.protobuf.BoolValue Cancels HTTP read-only queries (e.g. SELECT) when a client closes the connection without waiting for the response. Default value: false. More info see in ClickHouse documentation.
max_http_get_redirects	google.protobuf.Int64Value Limits the maximum number of HTTP GET redirect hops for URL-engine tables. If the parameter is set to 0 (default), no hops is allowed. More info see in ClickHouse documentation.
joined_subquery_requires_alias	google.protobuf.BoolValue
join_use_nulls	google.protobuf.BoolValue
transform_null_in	google.protobuf.BoolValue
quota_mode	enum QuotaMode Quota accounting mode. Possible values: QUOTA_MODE_DEFAULT, QUOTA_MODE_KEYED and QUOTA_MODE_KEYED_BY_IP.
flatten_nested	google.protobuf.BoolValue Sets the data format of a nested columns. More info see in ClickHouse documentation.
format_regexp	string Regular expression (for Regexp format)
format_regexp_escaping_rule	enum FormatRegexpEscapingRule See in-depth description in ClickHouse documentation.
format_regexp_skip_unmatched	google.protobuf.BoolValue See in-depth description in ClickHouse documentation.
async_insert	google.protobuf.BoolValue Enables asynchronous inserts. Disabled by default. More info see in ClickHouse documentation.
async_insert_threads	google.protobuf.Int64Value The maximum number of threads for background data parsing and insertion. If the parameter is set to 0, asynchronous insertions are disabled. Default value: 16. More info see in ClickHouse documentation.
wait_for_async_insert	google.protobuf.BoolValue Enables waiting for processing of asynchronous insertion. If enabled, server returns OK only after the data is inserted. More info see in ClickHouse documentation.
wait_for_async_insert_timeout	google.protobuf.Int64Value The timeout (in seconds) for waiting for processing of asynchronous insertion. Default value: 120. More info see in ClickHouse documentation.
async_insert_max_data_size	google.protobuf.Int64Value The maximum size of the unparsed data in bytes collected per query before being inserted. If the parameter is set to 0, asynchronous insertions are disabled. Default value: 100000. More info see in ClickHouse documentation.
async_insert_busy_timeout	google.protobuf.Int64Value The maximum timeout in milliseconds since the first INSERT query before inserting collected data. If the parameter is set to 0, the timeout is disabled. Default value: 200. More info see in ClickHouse documentation.
async_insert_stale_timeout	google.protobuf.Int64Value The maximum timeout in milliseconds since the last INSERT query before dumping collected data. If enabled, the settings prolongs the async_insert_busy_timeout with every INSERT query as long as async_insert_max_data_size is not exceeded. More info see in ClickHouse documentation.
memory_profiler_step	google.protobuf.Int64Value Memory profiler step (in bytes). If the next query step requires more memory than this parameter specifies, the memory profiler collects the allocating stack trace. Values lower than a few megabytes slow down query processing. Default value: 4194304 (4 MB). Zero means disabled memory profiler.
memory_profiler_sample_probability	google.protobuf.DoubleValue Collect random allocations and deallocations and write them into system.trace_log with 'MemorySample' trace_type. The probability is for every alloc/free regardless to the size of the allocation. Possible values: from 0 to 1. Default: 0.
compile	google.protobuf.BoolValue The setting is deprecated and has no effect.
min_count_to_compile	google.protobuf.Int64Value The setting is deprecated and has no effect.

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 Whether the host should get a public IP address on creation. After a host has been created, this setting cannot be changed. To remove an assigned public IP, or to assign a public IP to a host without one, recreate the host with assign_public_ip set as needed. Possible values: 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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

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 Object Storage.
maintenance_window	MaintenanceWindow New maintenance window settings for the cluster.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). 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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

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 Type of the storage environment for the host. Possible values: 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 Whether the host should get a public IP address on creation. After a host has been created, this setting cannot be changed. To remove an assigned public IP, or to assign a public IP to a host without one, recreate the host with assign_public_ip set as needed. Possible values: 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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

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 restore from. This backup will be used to create one cluster shard. To get the backup ID, use a ClusterService.ListBackups request.
additional_backup_ids[]	string Additional IDs of the backups to restore from. Each additional backup is responsible for restoring separate shard. Restored cluster will have len(additional_backup_ids)+1 shards in total. 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 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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: 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 Whether the host should get a public IP address on creation. After a host has been created, this setting cannot be changed. To remove an assigned public IP, or to assign a public IP to a host without one, recreate the host with assign_public_ip set as needed. Possible values: 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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

RescheduleMaintenance

Reschedules 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. ID of the ClickHouse cluster to reschedule the maintenance operation for. The maximum string length in characters is 50.
reschedule_type	enum RescheduleType Required. The type of reschedule request. IMMEDIATE: Start the maintenance operation immediately. NEXT_AVAILABLE_WINDOW: Start the maintenance operation within the next available maintenance window. SPECIFIC_TIME: Start the maintenance operation at the specific time.
delayed_until	google.protobuf.Timestamp The time until which this maintenance operation should be delayed. The value should be ahead of the first time when the maintenance operation has been scheduled for no more than two weeks. The value can also point to the past moment of time if reschedule_type.IMMEDIATE reschedule type is chosen.

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. The time until which this maintenance operation is to be delayed.

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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

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 the 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 A filter expression that filters resources listed in the response. The expression must specify: The field name. Currently filtering can be applied to the LogRecord.logs.message.hostname, LogRecord.logs.message.severity fields. An = operator. The value in double quotes ("). Must be 1-63 characters long and match the regular expression [a-z0-9.-]{1,61}. Examples of a filter: message.hostname='node1.db.cloud.yandex.net' message.severity IN ('Error', 'Fatal') AND message.hostname != 'node2.db.cloud.yandex.net'. 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 the 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 the 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 the 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 MDB hosts that exist on the platform, 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 Type of the storage environment for the host. Possible values: 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 Whether the host should get a public IP address on creation. After a host has been created, this setting cannot be changed. To remove an assigned public IP, or to assign a public IP to a host without one, recreate the host with assign_public_ip set as needed. Possible values: 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.

UpdateHosts

Updates the specified hosts.

rpc UpdateHosts (UpdateClusterHostsRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:UpdateClusterHostsMetadata

    Operation.response:google.protobuf.Empty

UpdateClusterHostsRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to update hosts in. To get the ClickHouse cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
update_host_specs[]	UpdateHostSpec New configurations to apply to hosts. The number of elements must be greater than 0.

UpdateHostSpec

Field	Description
host_name	string Required. Name of the host to update. To get the ClickHouse host name, use a ClusterService.ListHosts request.
update_mask	google.protobuf.FieldMask Field mask that specifies which fields of the ClickHouse host should be updated.
assign_public_ip	google.protobuf.BoolValue Whether the host should get a public IP address on creation.

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<UpdateClusterHostsMetadata> 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.

UpdateClusterHostsMetadata

Field	Description
cluster_id	string ID of the ClickHouse cluster to modify hosts in.
host_names[]	string Names of hosts that are being modified.

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 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.

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

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 the 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.

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

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.

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 Type of the storage environment for the host. Possible values: 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 Whether the host should get a public IP address on creation. After a host has been created, this setting cannot be changed. To remove an assigned public IP, or to assign a public IP to a host without one, recreate the host with assign_public_ip set as needed. Possible values: 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.

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

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. To get the cluster ID, make a ClusterService.List request. 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, make 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 ClickHouse cluster that the shard group belongs to.
description	string Description of the shard group. 0-256 characters long.
shard_names[]	string List of shard names contained in the 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. To get the cluster ID, make 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 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 the previous list request. The maximum string length in characters is 100.

ListClusterShardGroupsResponse

Field	Description
shard_groups[]	ShardGroup List of ClickHouse cluster's 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 ClickHouse cluster that the shard group belongs to.
description	string Description of the shard group. 0-256 characters long.
shard_names[]	string List of shard names contained in the 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 cluster ID, make 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 new shard group. 0-256 characters long.
shard_names[]	string List of shard names that should be put into the new group. To get the list, make a ClusterService.ListShardGroups request.

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 cluster to add a shard group to.
shard_group_name	string Name of the shard group that is being added.

ShardGroup

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

UpdateShardGroup

Updates 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 ClickHouse cluster that contains the shard group to update. To get the cluster ID, make a ClusterService.List request. The maximum string length in characters is 50.
shard_group_name	string Required. Name of the shard group that should be updated. To get the name, make a ClusterService.ListShardGroups request. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.
update_mask	google.protobuf.FieldMask
description	string Updated description of the shard group. 0-256 characters long.
shard_names[]	string Updated list of shard names that belongs to the shard 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 is being updated.

ShardGroup

Field	Description
name	string Name of the shard group.
cluster_id	string ID of the ClickHouse cluster that the shard group belongs to.
description	string Description of the shard group. 0-256 characters long.
shard_names[]	string List of shard names contained in the 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 that contains the shard group to delete. To get the cluster ID, make a ClusterService.List request. The maximum string length in characters is 50.
shard_group_name	string Required. Name of the shard group that should be deleted. To get the name, make a ClusterService.ListShardGroups 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<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 cluster that contains the shard group being deleted.
shard_group_name	string Name of the shard group that is being 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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

UpdateExternalDictionary

Updates an external dictionary for the specified ClickHouse cluster.

rpc UpdateExternalDictionary (UpdateClusterExternalDictionaryRequest) returns (operation.Operation)

Metadata and response of Operation:

    Operation.metadata:UpdateClusterExternalDictionaryMetadata

    Operation.response:Cluster

UpdateClusterExternalDictionaryRequest

Field	Description
cluster_id	string Required. ID of the ClickHouse cluster to update the external dictionary for. To get the cluster ID, use a List request. The maximum string length in characters is 50.
external_dictionary	config.ClickhouseConfig.ExternalDictionary Configuration of the external dictionary.
update_mask	google.protobuf.FieldMask Field mask that specifies which fields of the External Dictionary should be updated.

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<UpdateClusterExternalDictionaryMetadata> 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.

UpdateClusterExternalDictionaryMetadata

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

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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.

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 Object Storage.
maintenance_window	MaintenanceWindow Maintenance window for the cluster.
planned_operation	MaintenanceOperation Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
security_group_ids[]	string User security groups
deletion_protection	bool Deletion Protection inhibits deletion of the cluster

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.
embedded_keeper	google.protobuf.BoolValue Whether cluster should use embedded Keeper instead of Zookeeper.

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 DataLens.
web_sql	bool Allow SQL queries to the cluster databases from the 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 AppMetrica documentation for more details.
serverless	bool Allow access to cluster for Serverless.
data_transfer	bool Allow access for DataTransfer
yandex_query	bool Allow access for Query

CloudStorage

Field	Description
enabled	bool Whether to use Object Storage for storing ClickHouse data.
move_factor	google.protobuf.DoubleValue Acceptable values are 0 to 1, inclusive.
data_cache_enabled	google.protobuf.BoolValue
data_cache_max_size	google.protobuf.Int64Value

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 Type of the storage environment for the host. Possible values: network-hdd - network HDD drive, network-ssd - network SSD drive, local-ssd - local SSD storage.

MaintenanceWindow

Field	Description
policy	oneof: anytime or weekly_maintenance_window The maintenance policy in effect.
anytime	AnytimeMaintenanceWindow Maintenance operation can be scheduled anytime.
weekly_maintenance_window	WeeklyMaintenanceWindow Maintenance operation can be scheduled on a weekly basis.

AnytimeMaintenanceWindow

WeeklyMaintenanceWindow

Field	Description
day	enum WeekDay Day of the week (in DDD format).
hour	int64 Hour of the day in UTC (in HH format). Acceptable values are 1 to 24, inclusive.

MaintenanceOperation

Field	Description
info	string Information about this maintenance operation. The maximum string length in characters is 256.
delayed_until	google.protobuf.Timestamp Time until which this maintenance operation is delayed.