variable "account" {
  type        = string
  description = "Snowflake account name"
  default     = "DELPHI"
}

variable "region" {
  type        = string
  description = "Snowflake account region"
  default     = "us-east-1"
}

variable "database_name" {
  type        = string
  description = "The name of the database (must be upper-case)."
  default     = "SME_DATA_SCIENCE_AND_ANALYTICS"
}

variable "schemas" {
  type = list(object({
    name                 = string
    is_managed           = optional(bool, true)
    create_roles         = optional(bool, true)
    read_role_name       = optional(string)
    read_write_role_name = optional(string)
    data_retention_days  = optional(number, 1)
    is_transient         = optional(bool, false)
    log_level            = optional(string)
    trace_level          = optional(string)
  }))
  description = "A list of schemas to create in the database"
  default = [
    { name = "FIRST_35", is_managed = false, create_roles = true },
    { name = "PUBLIC", is_managed = false, create_roles = true },
    { name = "PROD", is_managed = true, create_roles = true },
    { name = "QA", is_managed = true, create_roles = true },
  ]
}