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     = "INTEGRATION"
}

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

variable "read_write_role_name" {
  description = "The name of the read write database role."
  default     = "INTEGRATION_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       = "ABC",
      is_managed = false
    },
    {
      name       = "ABOVEBOARD",
      is_managed = false
    },
    {
      name       = "ABRSM",
      is_managed = false
    },
    {
      name       = "ABSCBN",
      is_managed = false
    },
    {
      name       = "ACE",
      is_managed = false
    },
    {
      name       = "ADJEXP",
      is_managed = false
    },
    {
      name       = "ALTAFONTE",
      is_managed = false
    },
    {
      name       = "AMBITION",
      is_managed = false
    },
    {
      name       = "ANIMAJ",
      is_managed = false
    },
    {
      name       = "ARTISTFIRST",
      is_managed = false
    },
    {
      name       = "AWAL",
      is_managed = false
    },
    {
      name       = "BALLOON",
      is_managed = false
    },
    {
      name       = "BEATROOT",
      is_managed = false
    },
    {
      name       = "BITBIRD",
      is_managed = false
    },
    {
      name       = "BLACKSCREEN",
      is_managed = false
    },
    {
      name       = "CATMUSIC",
      is_managed = false
    },
    {
      name       = "CENTERSTAGE",
      is_managed = false
    },
    {
      name       = "CROATIA",
      is_managed = false
    },
    {
      name       = "CRSTUDIONAPOLI",
      is_managed = false
    },
    {
      name       = "CRUX",
      is_managed = false
    },
    {
      name       = "DAO",
      is_managed = false
    },
    {
      name       = "DEV",
      is_managed = false
    },
    {
      name       = "DISTILLER",
      is_managed = false
    },
    {
      name       = "DRM",
      is_managed = false
    },
    {
      name       = "EERISING",
      is_managed = false
    },
    {
      name       = "ENCORE",
      is_managed = false
    },
    {
      name       = "EXPANDEDRECORDS",
      is_managed = false
    },
    {
      name       = "EXTREMEGROUP",
      is_managed = false
    },
    {
      name       = "FABRIQUE",
      is_managed = false
    },
    {
      name       = "FAIRTRADE",
      is_managed = false
    },
    {
      name       = "FLUVE",
      is_managed = false
    },
    {
      name       = "FMRECORDS",
      is_managed = false
    },
    {
      name       = "FOUNDATION",
      is_managed = false
    },
    {
      name       = "GAGAKU",
      is_managed = false
    },
    {
      name       = "GALLO",
      is_managed = false
    },
    {
      name       = "GOLDENROBOT",
      is_managed = false
    },
    {
      name       = "GORGON",
      is_managed = false
    },
    {
      name       = "GOTEE",
      is_managed = false
    },
    {
      name       = "GRECORDS",
      is_managed = false
    },
    {
      name       = "HIKOON",
      is_managed = false
    },
    {
      name       = "HUMANRESOURCES",
      is_managed = false
    },
    {
      name       = "HUNGAROTON",
      is_managed = false
    },
    {
      name       = "IDESOSIALOKA",
      is_managed = false
    },
    {
      name       = "IDETIMUR",
      is_managed = false
    },
    {
      name       = "INDEPENDENT",
      is_managed = false
    },
    {
      name       = "KOSEM",
      is_managed = false
    },
    {
      name       = "LANGVAN",
      is_managed = false
    },
    {
      name       = "LIFTED",
      is_managed = false
    },
    {
      name       = "LOFIGIRL",
      is_managed = false
    },
    {
      name       = "MARSHALL",
      is_managed = false
    },
    {
      name       = "MIXUS",
      is_managed = false
    },
    {
      name       = "MOORELAKE",
      is_managed = false
    },
    {
      name       = "NCTLOOPS",
      is_managed = false
    },
    {
      name       = "NQRECORDS",
      is_managed = false
    },
    {
      name       = "NUDASARL",
      is_managed = false
    },
    {
      name       = "OKLISTEN",
      is_managed = false
    },
    {
      name       = "ONTHERADAR",
      is_managed = false
    },
    {
      name       = "OOOACAPELLA",
      is_managed = false
    },
    {
      name       = "PHILLIPSCRAIGDEAN",
      is_managed = false
    },
    {
      name       = "PLATINUM",
      is_managed = false
    },
    {
      name       = "POLLMUSIC",
      is_managed = false
    },
    {
      name       = "POPUP",
      is_managed = false
    },
    {
      name       = "PROD",
      is_managed = false
    },
    {
      name       = "PUBLIC",
      is_managed = false
    },
    {
      name       = "QA",
      is_managed = false
    },
    {
      name       = "RANKAKUSTANNUS",
      is_managed = false
    },
    {
      name       = "REACH",
      is_managed = false
    },
    {
      name       = "RHYMES",
      is_managed = false
    },
    {
      name       = "ROUNDHILL",
      is_managed = false
    },
    {
      name       = "RPM",
      is_managed = false
    },
    {
      name       = "SAREGAMA",
      is_managed = false
    },
    {
      name       = "SHADOWMOUNTAIN",
      is_managed = false
    },
    {
      name       = "SHENZHEN",
      is_managed = false
    },
    {
      name       = "SMESINGAPORE",
      is_managed = false
    },
    {
      name       = "STORM",
      is_managed = false
    },
    {
      name       = "SURFDOG",
      is_managed = false
    },
    {
      name       = "TOOTHANDNAIL",
      is_managed = false
    },
    {
      name       = "TVB",
      is_managed = false
    },
    {
      name       = "UNIQUEVIBES",
      is_managed = false
    },
    {
      name       = "V2_RECORDS",
      is_managed = false
    },
    {
      name       = "VIANET",
      is_managed = false
    },
    {
      name       = "WINGHANG",
      is_managed = false
    },
    {
      name       = "XTRA_MILE",
      is_managed = false
    },
    {
      name       = "YEG",
      is_managed = false
    },
    {
      name       = "YOUNGFORYOU",
      is_managed = false
    },
  ]
}