provider "snowflake" {
  account_name = "delphi"
}

terraform {
  backend "s3" {
    bucket  = "orcd-terraform-state"
    key     = "prod/snowflake/delphi/databases/data_apps/additional_roles/terraform.tfstate"
    region  = "us-east-1"
    encrypt = "true"
  }
}

module "qa_streamlit_database_role_delete_sme_product" {
  for_each = toset(["QA"])
  source   = "git@github.com:theorchard/terraform-snowflake.git//modules/roles/streamlit_access?ref=7.1.0"

  database     = var.database_name
  schema       = each.value
  streamlit_id = "DELETE_SME_PRODUCT"
}


module "prod_streamlit_database_role_delete_sme_product" {
  for_each = toset(["PROD"])
  source   = "git@github.com:theorchard/terraform-snowflake.git//modules/roles/streamlit_access?ref=7.1.0"

  database     = var.database_name
  schema       = each.value
  streamlit_id = "DELETE_SME_PRODUCT"
}