yandex_mdb_clickhouse_database (Resource)
Written by
Updated at April 9, 2026
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"
}
Arguments & Attributes Reference
cluster_id(Required)(String). ID of the ClickHouse cluster. Provided by the client when the database is created.engine(String). Database engine, possible values are: atomic,replicated.id(Read-Only) (String). The resource identifier.name(Required)(String). The name of the database.timeouts[Block].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 it you can use Yandex Cloud Web Console or Yandex Cloud CLI.
# terraform import yandex_mdb_clickhouse_database.<resource Name> <resource Id>
terraform import yandex_mdb_clickhouse_database.my_db1 cluster_id:my_dbname