provider "snowflake" {
  account_name = "delphi"
  role         = "PROD_ATLANTIS"
}

module "database" {
  source = "../../modules/database"

  database_name = "TERRAFORM_SNOWFLAKE_TEST"

  enable_account_roles  = true
  enable_database_roles = true

  deployment_warehouse_role = "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS"

  schemas = [
    {
      name                   = "SCHEMA_A"
      create_deployment_role = true
    },
    {
      name                 = "SCHEMA_B"
      read_role_name       = "SCHEMA_B_CUSTOM_RO_ROLE_NAME"
      read_write_role_name = "SCHEMA_B_CUSTOM_RW_ROLE_NAME"
      data_retention_days  = 2
    }
  ]
}