Snowflake Data Quality Sentinel

What it does

When your agent uses it

• Monitoring coverage may be incomplete
• With Snowflake data quality
• DMF expectation
• Definition drift

Example prompts

• “Snowflake data quality”
• “DMF expectation”
• “definition drift”
• “/snowflake-data-quality-sentinel”

Requirements

• Python 3
• Compatibility (from SKILL.md): Model-neutral; requires Python 3.10+. Optional collection requires Snowflake CLI with an existing read-only profile.
• Pre-approved tools (allowed-tools): Read, Bash(python3:*)

Workflow steps

3 steps, taken from the step headings in SKILL.md.

1. 1Collect evidence
2. 2Establish trust and analyze
3. 3Interpret the result

What it can do on your machine

Read from SKILL.md and the folder at commit cfae287. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves these tools, so the agent can use them without asking each time:

  • Read
  • Bash(python3:*)

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Ships 6 files in scripts/ (Python), which the agent can run.

  Shell commands in SKILL.md call:

  • python3

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  Links to these hosts (documentation or services it may open):

  • docs.snowflake.com

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names no API keys, tokens, secrets or passwords.

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

• Compatibility

  Model-neutral; requires Python 3.10+. Optional collection requires Snowflake CLI with an existing read-only profile.

  From compatibility in the SKILL.md frontmatter.

Context cost

Snowflake Data Quality Sentinel loads about 2k tokens when it runs, and up to ~3.8k if it reads all its reference files. Until then it costs about 99 tokens; SKILL.md has 629 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~99

When it runs · the whole SKILL.md, loaded when a task matches

~2k

With references · SKILL.md plus every file in references/, read only if the agent opens them

~3.8k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from jeremylongshore/tons-of-skills-marketplace at commit cfae287, republished under its MIT licence (© jeremylongshore). 629 words, ~1,990 tokens.

name

snowflake-data-quality-sentinel

description

Assess trusted Snowflake data metric function coverage and expectation evidence without reading customer rows. Use when evaluations, definitions, schedules, notifications, anomaly state, or monitoring coverage may be incomplete or unhealthy. Trigger with "Snowflake data quality", "DMF expectation", "definition drift", "missing evaluation", or "notification gap".

allowed-tools

Read, Bash(python3:*)

compatibility

Model-neutral; requires Python 3.10+. Optional collection requires Snowflake CLI with an existing read-only profile.

argument-hint

[schema-2-evidence.json]

model

inherit

effort

high

version

3.16.0

author

Jeremy Longshore <jeremy@intentsolutions.io>

license

MIT

tags

saas, snowflake, data-quality, governance, observability, incident-response

# Example fixed UTC window; replace with the audited interval.
python3 "${CLAUDE_SKILL_DIR}/scripts/collect_snowflake_evidence.py" \
  --surface data-quality --connection readonly-observer \
  --window-start 2026-09-01T00:00:00Z --window-end 2026-09-02T00:00:00Z \
  --output ./dq-history.json

python3 "${CLAUDE_SKILL_DIR}/scripts/collect_snowflake_evidence.py" \
  --surface data-quality-associations-current --connection readonly-observer \
  --data-quality-object GOVERNED_DB.GOVERNED_SCHEMA.GOVERNED_TABLE \
  --data-quality-domain TABLE \
  --output ./dq-associations.json

python3 "${CLAUDE_SKILL_DIR}/scripts/collect_snowflake_evidence.py" \
  --surface data-quality-expectations-current --connection readonly-observer \
  --data-quality-object GOVERNED_DB.GOVERNED_SCHEMA.GOVERNED_TABLE \
  --data-quality-domain TABLE \
  --output ./dq-expectations.json

python3 "${CLAUDE_SKILL_DIR}/scripts/collect_snowflake_evidence.py" \
  --surface data-quality-notification-current --connection readonly-observer \
  --data-quality-object GOVERNED_DB.GOVERNED_SCHEMA.GOVERNED_TABLE \
  --data-quality-domain TABLE --output ./dq-notification.json

# Record these at their independent trusted local boundaries.
python3 "${CLAUDE_SKILL_DIR}/scripts/analyze_data_quality.py" evidence.json \
  --print-input-sha256
python3 "${CLAUDE_SKILL_DIR}/scripts/analyze_data_quality.py" \
  --policy-file policy.json --print-policy-sha256

python3 "${CLAUDE_SKILL_DIR}/scripts/analyze_data_quality.py" evidence.json \
  --policy-file policy.json \
  --evaluated-at 2026-09-03T12:00:00Z \
  --trusted-input-sha256 sha256:RECORD_FROM_EVIDENCE_BOUNDARY \
  --trusted-policy-sha256 sha256:RECORD_FROM_POLICY_BOUNDARY --pretty

© jeremylongshore, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 10 other files (scripts, references) in skills/.curated/snowflake-data-quality-sentinel of jeremylongshore/tons-of-skills-marketplace.

• SKILL.md
• eval-spec.yaml
• references/input-contract.md
• references/source-notes.md
• scripts/analyze_data_quality.py
• scripts/collect_snowflake_evidence.py
• scripts/sql/data-quality-associations-current.sql
• scripts/sql/data-quality-expectations-current.sql
• scripts/sql/data-quality-notification-current.sql
• scripts/sql/data-quality.sql
• tests/test_analyze_data_quality.py

Open the folder on GitHubat commit cfae287