snowflake-query-forensics
Pass
Audited by Gen Agent Trust Hub on Oct 22, 2026
Risk Level: SAFE
Full Analysis
- [SAFE]: The skill implements a strong security posture focused on data privacy and read-only access to Snowflake environments.
- Redaction Logic: Both
scripts/analyze_query_evidence.pyandscripts/collect_snowflake_evidence.pycontain sophisticated redaction mechanisms. They use regular expressions and tokenization to identify and mask Authorization headers, passwords, tokens, and raw SQL fragments within query history and error messages. - Data Pseudonymization: Sensitive identifiers such as
user_nameandquery_tagare pseudonymized using SHA-256 hashes directly within the Snowflake SQL collection template (scripts/sql/query.sql) before the data reaches the agent context. - Integrity Verification: The skill uses a digest-based trust anchor system (
--trusted-input-sha256). This allows operators to record a canonical digest at a trusted local boundary to ensure evidence hasn't been tampered with before analysis. - Mutation Prevention:
scripts/collect_snowflake_evidence.pyincludes avalidate_read_only_sqlfunction that scans SQL for forbidden mutation keywords (e.g.,ALTER,DROP,DELETE,GRANT) and unsupported system functions, ensuring the agent cannot execute destructive commands. - Input Validation: Command-line arguments for scripts are strictly validated against specific regex patterns (e.g., Snowflake UUIDs, identifiers, and UTC timestamps), effectively preventing command injection vulnerabilities.
Audit Metadata