provider "snowflake" {
  account_name = "delphi"
}

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

module "dynamic_table_database_role_songwhip_fan_responses" {
  for_each = toset([
    "SONGWHIP_FAN_RESPONSES_LATIN_US",
  ])

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

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

module "dynamic_table_database_role_songwhip_fan_collection" {
  for_each = toset([
    "SONGWHIP_FAN_RESPONSES_DYNAMIC",
  ])

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

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

module "dynamic_table_database_role_songwhip_pages" {
  for_each = toset([
    "SONGWHIP_FAN_COLLECTION_PAGES_MASTER",
  ])

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

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