snowflake-query-forensics
Pass
Audited by Gen Agent Trust Hub on Sep 9, 2026
Risk Level: SAFEINDIRECT_PROMPT_INJECTIONCOMMAND_EXECUTIONDYNAMIC_EXECUTION
Full Analysis
- [INDIRECT_PROMPT_INJECTION]: The skill ingests Snowflake query history, operator statistics, and platform insights which are externally controlled data sources. Ingestion points: The
scripts/collect_snowflake_evidence.pyscript captures Snowflake CLI output, andscripts/analyze_query_evidence.pyprocesses these as input JSON files. Boundary markers: The skill employs a 'Trusted Local Digest' mechanism (--trusted-input-sha256) to verify evidence provenance and strictly enforces contract versions. Capability inventory: The skill is capable of executing Snowflake CLI commands and writing forensic reports in JSON and Markdown formats. Sanitization: A comprehensive recursive redaction engine inscripts/analyze_query_evidence.pyfilters credentials, raw SQL, URLs, and emails from all output fields. - [COMMAND_EXECUTION]: The
scripts/collect_snowflake_evidence.pyscript invokes thesnowCLI viasubprocess.runto execute diagnostic SQL. The command uses a list of arguments for safety, and the connection profile identifier is validated against a strict regex. - [DYNAMIC_EXECUTION]: The
render_surfacefunction inscripts/collect_snowflake_evidence.pyperforms string substitution to inject identifiers into reviewed SQL templates. While this creates a dynamic execution path, all substituted identifiers (database, user, role) are validated against unquoted Snowflake identifier patterns before injection.
Audit Metadata