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

variable "read_role_name" {
  description = "The name of the read only database role."
  default     = "INTELLIGENCE_DB_READ_ONLY"
}

variable "read_write_role_name" {
  description = "The name of the read write database role."
  default     = "INTELLIGENCE_DB_READ_WRITE"
}

variable "schemas" {
  type = list(object({
    name         = string
    is_managed   = optional(bool, true)
    create_roles = optional(bool, true)
  }))
  description = "A list of schemas to create in the database"
  default = [
    {
      name       = "DBT_PROD",
      is_managed = false
    },
    {
      name       = "DBT_PROD_PROJECT_MOMENTS",
      is_managed = false
    },
  ]
}