variable "account" {
  description = "The Snowflake account name."
  default     = "delphi"
}

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

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