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

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

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 = "CONSOLIDATION_DATA", is_managed = false, create_roles = true },
    { name = "FIVETRAN_HYDROLYSIS_ENVISION_STAGING", is_managed = false, create_roles = false },
    { name = "FIVETRAN_LOG", is_managed = false, create_roles = false },
    { name = "SHOPIFY_AU_NZ_THE_THREAD_SHOP", is_managed = false, create_roles = false },
    { name = "SHOPIFY_COR_DAFT_PUNK_2", is_managed = false, create_roles = false },
    { name = "SHOPIFY_COR_DON_TOLIVER", is_managed = false, create_roles = false },
    { name = "SHOPIFY_COR_ICECOLDBISHOP", is_managed = false, create_roles = false },
    { name = "SHOPIFY_COR_JACK_WHITE", is_managed = false, create_roles = false },
    { name = "SHOPIFY_COR_MEGAN_MORONEY", is_managed = false, create_roles = true },
    { name = "SHOPIFY_COR_THE_DEAD_WEATHER", is_managed = false, create_roles = false },
    { name = "SHOPIFY_COR_THE_RACONTEURS", is_managed = false, create_roles = false },
    { name = "SHOPIFY_COR_THE_WHITE_STRIPES", is_managed = false, create_roles = false },
    { name = "SHOPIFY_THE_ORCHARD_DPR_IAN", is_managed = false, create_roles = false },
    { name = "SHOPIFY_THE_ORCHARD_ERIC_NAM", is_managed = false, create_roles = false },
    { name = "SHOPIFY_THE_ORCHARD_FRONTIERS_US", is_managed = false, create_roles = false },
    { name = "SHOPIFY_THE_ORCHARD_RAYE_2", is_managed = false, create_roles = false },
    { name = "SHOPIFY_UK_ARCADE_FIRE_2", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_BAD_BOY_CHILLER_CREW", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_BAKAR", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_BERWYN", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_BLACK_BUTTER", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_BOB_DYLAN", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_BRING_ME_THE_HORIZON", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_CALVIN_HARRIS", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_CAT_BURNS_2", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_DAFT_PUNK", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_DECLAN_MCKENNA", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_DECLAN_MCKENNA_EU", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_EVERYONE_YOU_KNOW", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_FIRST_AID_KIT_2", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_FREDO", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_GALEN_PAUL", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_GEORGE_EZRA", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_GEORGE_MICHAEL", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_GEORGE_MICHAEL_US", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_HARRYS_HOUSE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_HEADIE_ONE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_JAKE_BUGG", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_JAMES_ARTHUR", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_JAMES_VINCENT_MCMORROW", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_JOY_CROOKES", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_JUDAS_PRIEST", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_KASABIAN", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_KOFFEE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_LAST_CHRISTMAS", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_LITTLE_MIX", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_LOL_SURPRISE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_LONDON_GRAMMAR", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_LOVE_REGENERATOR", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_MANIC_STREET_PREACHERS", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_MICHAEL_JACKSON", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_MIMI_WEBB_2", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_MINISTRY_OF_SOUND", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_NOAH_CYRUS", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_NOTHING_BUT_THIEVES", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_OZZY_OSBOURNE_2", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_PALOMA_FAITH", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_PINK", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_PIP_MILLETT_2", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_PRIMAL_SCREAM", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_REX_ORANGE_COUNTY", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_RUSS_MILLIONS", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_SADE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_SCOUTING_FOR_GIRLS", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_SIGALA", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_STEPS_2", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_TATE_MCRAE_2", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_TEMS", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_THE_SCRIPT", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_THE_SCRIPT_EU", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_TOM_GRENNAN", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_WHAM", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_YOUNG_T_AND_BUGSEY", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_NASHVILLE_ADAM_DOLEAC", is_managed = false, create_roles = false },
    { name = "SHOPIFY_US_NASHVILLE_KANE_BROWN", is_managed = false, create_roles = false },
    { name = "SHOPIFY_US_NASHVILLE_RESTLESS_ROAD", is_managed = false, create_roles = false },
    { name = "SHOPIFY_US_RCA_TATE_MCRAE", is_managed = false, create_roles = false },
    { name = "STAGE_CONSOLIDATION_DATA", is_managed = false, create_roles = true },
    { name = "WOOCOMMERCE_ITALY", is_managed = false, create_roles = false },
    { name = "SHOPIFY_US_COLUMBIA_ADDISON_RAE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_ADDISON_RAE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_AU_NZ_ADDISON_RAE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_ARISTA_DAMIANO_DAVID", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_COLUMBIA_DOMINIC_FIKE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_RCA_DOJA_CAT", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_DOJA_CAT", is_managed = false, create_roles = true },
    { name = "SHOPIFY_AU_NZ_DOJA_CAT", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_EPIC_GIVEON", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_COLUMBIA_JENNIE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_RCA_LIZZY_MCALPINE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_COLUMBIA_MALCOLM_TODD", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_RCA_SZA", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_COLUMBIA_THE_KID_LAROI", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_COLUMBIA_TAME_IMPALA", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_TAME_IMPALA", is_managed = false, create_roles = true },
    { name = "SHOPIFY_AU_NZ_TAME_IMPALA", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_EPIC_TYLA", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_PERRIE_EDWARDS", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_JAKE_BUGG_2", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_CENTRAL_CEE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_BRADLEY_SIMPSON", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_LISA", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_MYLES_SMITH", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_QUEEN", is_managed = false, create_roles = true },
    { name = "SHOPIFY_UK_RENEGADE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_DE_RENEGADE_EU", is_managed = false, create_roles = true },
    { name = "SHOPIFY_AU_NZ_RENEGADE", is_managed = false, create_roles = true },
    { name = "SHOPIFY_US_COLUMBIA_RENEGADE", is_managed = false, create_roles = true },
  ]
}