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

  database = "LORELAI_AGENT"
  schema   = "DEV"
  agent    = "LORELAI"
}

resource "snowflake_execute" "agent_monitor_grant" {
  execute = "GRANT MONITOR ON AGENT LORELAI_AGENT.DEV.LORELAI TO DATABASE ROLE LORELAI_AGENT.DB_DEV_SCHEMA_LORELAI_AGENT_USAGE"
  revert  = "REVOKE MONITOR ON AGENT LORELAI_AGENT.DEV.LORELAI FROM DATABASE ROLE LORELAI_AGENT.DB_DEV_SCHEMA_LORELAI_AGENT_USAGE"
}