Yandex Cloud
Documentation
PresentationContact UsTry it for free
© 2026 Direct Cursus Technology L.L.C.
Terraform in Yandex Cloud
  • Getting started
  • Setting up Yandex Cloud Terraform provider authentication
  • Solution library
    • Overview
    • Release notes
          • mdb_clickhouse_cluster
          • mdb_clickhouse_cluster_change_freeze
          • mdb_clickhouse_cluster_iam_binding
          • mdb_clickhouse_cluster_v2
          • mdb_clickhouse_database
          • mdb_clickhouse_user

In this article:

  • Example usage
  • Arguments & Attributes Reference
  • Import
  1. Terraform reference
  2. Resources
  3. Managed Service for ClickHouse
  4. Resources
  5. mdb_clickhouse_database

yandex_mdb_clickhouse_database (Resource)

Written by
Yandex Cloud
Updated at November 5, 2026
View in Markdown
  • Example usage
  • Arguments & Attributes Reference
  • Import

A database of the ClickHouse cluster.

Example usageExample 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 ReferenceArguments & Attributes Reference

  • cluster_id (Required)(String). ID of the ClickHouse cluster. Provided by the client when the database is created.
  • deletion_protection_mode (String). Deletion protection mode of the database. Possible values: DELETION_PROTECTION_MODE_INHERITED (default) - the database is protected if deletion_protection is enabled for the cluster, DELETION_PROTECTION_MODE_ENABLED - the database is protected regardless of the cluster setting, DELETION_PROTECTION_MODE_DISABLED - the database can be deleted even if the cluster is protected. The mode does not prevent deletion of the cluster.
  • 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.
    • update (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).

ImportImport

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

Was the article helpful?

Previous
mdb_clickhouse_cluster_v2
Next
mdb_clickhouse_user
© 2026 Direct Cursus Technology L.L.C.