provider "snowflake" {
  account_name = "delphi"
}

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

module "table_database_role_prod" {
  for_each = toset([
    "LINKFIRE_RAW_DATA",
  ])

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

  database = var.database_name
  schema   = "EXP"
  table    = each.value
}

module "table_database_role_chatbot_agent_chartmetric" {
  for_each = toset([
    "CM_TRACK",
  ])

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

  database = var.database_name
  schema   = "CHARTMETRIC"
  table    = each.value
}