Skip to main content

​
Local

env "local" {
  url = "http://default:password@localhost:8123/mydb"

  migrations {
    dir = "migrations"
  }
}

​
Staging

env "staging" {
  url = env("CLICKHOUSE_STAGING_URL")

  migrations {
    dir = "migrations"

    vars = {
      replication_factor = 2
      ttl_days = 30
    }
  }
}

​
Production

env "production" {
  url = env("CLICKHOUSE_PROD_URL")
  exclude = ["system.*", "_tmp_*"]

  tls {
    ca_file = env("CLICKHOUSE_CA_FILE")
    cert_file = env("CLICKHOUSE_CLIENT_CERT_FILE")
    key_file = env("CLICKHOUSE_CLIENT_KEY_FILE")
  }

  migrations {
    dir = "migrations"

    table {
      name = "schema_migrations"
      is_replicated = true
    }

    vars = {
      replication_factor = var.replication_factor
      ttl_days = 90
    }
  }
}

variable "replication_factor" {
  type = string
  default = "3"
}