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

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

variable "db_data_retention_time_in_days" {
  type    = number
  default = 1
}

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)
  }))
  description = "A list of schemas to create in the database"
  default = [
    { name = "AD_DATA", is_managed = false },
    { name = "APPS_ETL", is_managed = false },
    { name = "BAD", is_managed = false },
    { name = "CHARTMETRIC", is_managed = false },
    { name = "CHARTMETRIC_SYS", is_managed = false },
    { name = "EXP", is_managed = false },
    { name = "EXPLORATION_SANDBOX", is_managed = false },
    { name = "LINKFIRE", is_managed = false },
    { name = "LINKFIRE_APPLE_MUSIC", is_managed = false },
    { name = "MAIN", is_managed = false },
    { name = "RAW", is_managed = false },
    { name = "SYS", is_managed = false },
  ]
}