provider "snowflake" {
  account_name = "delphi"
}

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

module "dynamic_table_database_role_prod" {
  for_each = toset([
    "SMF_FAN_RESPONSES_UK",
    "SMF_FAN_RESPONSES_INSIGHTS",
    "SMF_FAN_RESPONSES_GSA",
    "SMF_FAN_RESPONSES_LATIN_US",
  ])

  source = "git@github.com:theorchard/terraform-snowflake.git//modules/roles/dynamic_table_access?ref=7.7.8"

  database      = var.database_name
  schema        = "SMF_FAN_RESPONSES"
  dynamic_table = each.value
}