SECOPS

Daily Auth-Anomaly Digest with Snowflake Enrichment

Runs once a day, pulls the prior 24 hours of Axiom auth anomalies, enriches each with employee and asset context from Snowflake.

CategorySecOps
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily schedule starts digest run
  • ActionQuery Axiom for 24h of auth anomaliesAxiom
  • ActionEnrich with employee/asset context from SnowflakeSnowflakeSnowflake
  • LogicScore and rank by blast radius and confidence
  • ActionPublish ranked digest to ConfluenceConfluenceConfluence
  • OutputPost digest summary to Slack for standupSlack

What it does

Produces a single, ranked daily digest of every auth anomaly — impossible travel, MFA skips, failed-login spikes — instead of scattered real-time alerts. Each entry is enriched with who the user is and what they can reach, so the standup can prioritize quickly.

When to use it

Use for teams that triage in a daily review rather than 24/7 paging, or as a companion report alongside real-time pagers. Requires an HR/asset table in Snowflake to join against.

How it works

  1. 1A daily schedule kicks off the digest run.
  2. 2The flow queries Axiom for all flagged anomalies in the trailing 24 hours.
  3. 3It joins each anomaly to Snowflake for employee department, role, and the sensitivity of systems that identity can access.
  4. 4A logic step scores and ranks anomalies by blast radius and confidence.
  5. 5It renders a structured digest — top risks first, with evidence links and recommended next steps.
  6. 6The digest is published as a Confluence page, and a short summary with the page link is posted to Slack ahead of the standup.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect AxiomLog streams, queries, dashboards.
  2. 2
    Connect SnowflakeWarehouses, queries, shares.
  3. 3
    Connect ConfluenceSpaces, pages, blueprints.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.