yandex_mdb_clickhouse_database (Resource)
Written by
Updated at September 11, 2025
A database of the ClickHouse cluster.
Example usage
resource "yandex_vpc_network" "foo" {}
resource "yandex_vpc_subnet" "foo" {
zone = "ru-central1-a"
network_id = yandex_vpc_network.foo.id
v4_cidr_blocks = ["10.5.0.0/24"]
}
resource "yandex_mdb_clickhouse_cluster" "foo" {
name = "test"
environment = "PRESTABLE"
network_id = yandex_vpc_network.foo.id
resources {
resource_preset_id = "s2.micro"
disk_type_id = "network-ssd"
disk_size = 32
}
config {
}
host {
type = "CLICKHOUSE"
zone = "ru-central1-a"
subnet_id = yandex_vpc_subnet.foo.id
}
service_account_id = "your_service_account_id"
maintenance_window {
type = "ANYTIME"
}
lifecycle {
ignore_changes = [database, user, ]
}
}
resource "yandex_mdb_clickhouse_database" "foo" {
cluster_id = yandex_mdb_clickhouse_cluster.foo.id
name = "database1"
}
resource "yandex_mdb_clickhouse_database" "bar" {
cluster_id = yandex_mdb_clickhouse_cluster.foo.id
name = "database2"
}
Schema
Required
cluster_id(String) ID of the ClickHouse cluster. Provided by the client when the database is created.name(String) The name of the database.
Optional
timeouts(Attributes) (see below for nested schema)
Read-Only
id(String) The resource identifier.
Nested Schema for timeouts
Optional:
create(String) A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).delete(String) A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
Import
The resource can be imported by using their resource ID. For getting the resource ID you can use Yandex Cloud Web Console or YC CLI.
# terraform import yandex_mdb_clickhouse_database.<resource Name> <resource Id>
terraform import yandex_mdb_clickhouse_database.my_db1 cluster_id:my_dbname