module "cortex_search_read_schema_role_DEV_RBOMBERG" {
  source = "git@github.com:theorchard/terraform-snowflake.git//modules/roles/schema_cortex_search_access?ref=7.7.8"

  database = var.database_name
  schema   = "DEV_RBOMBERG"
}

module "cortex_agent_read_role_CHATBOT_AGENT" {
  source = "git@github.com:theorchard/terraform-snowflake.git//modules/roles/agent_access?ref=7.7.8"

  database = var.database_name
  schema   = "DEV_RBOMBERG"
  agent    = "CHATBOT_AGENT"
}

module "view_database_role_chatbot_agent_dev_rbomberg" {
  for_each = toset([
    "V_STREAMS_SOS_UNPIVOTED",
  ])

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

  database = var.database_name
  schema   = "DEV_RBOMBERG"
  view     = each.value
}

module "table_database_role_chatbot_agent_dev_rbomberg" {
  for_each = toset([
    "CHATBOT_AGGREGATED_CHARTS",
    "REGION_COUNTRY_MAPPING",
    "STREAM_SOURCE_MAPPINGS",
  ])

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

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

module "dynamic_table_database_role_chatbot_agent_dev_rbomberg" {
  for_each = toset([
    "CHATBOT_GLOBAL_PARTICIPANT_BRAND_MAPPING",
    "CHATBOT_ISRC_ACCOUNT_MAPPING",
    "CHATBOT_ISRC_BRAND_MAPPING",
    "CHATBOT_TADAS_INPUT",
    "ISRC_TO_GLOBAL_PARTICIPANT_MAPPING",
  ])

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

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