{"data":{"skill":{"slug":"wshobson-dbt-transformation-patterns","name":"dbt-transformation-patterns","icon":"📦","repo":"https://github.com/wshobson/agents/tree/main/plugins/data-engineering/skills/dbt-transformation-patterns","status":"approved","author":"wshobson","authorVersion":null,"skillstoreRevision":null},"audit":{"id":"378f98df-b0ef-4bd1-9cd7-4a97138defcb","skill_id":"f12b41bc-c97e-41cf-9dbf-d311b1d1b962","version":7,"content_hash":"v2:36e07d5e13068e5be64447e8f20b427cf2cbd21a:bd1cfcd33c00f7f8acdd56548e632cd83edabb65f7d11d4addbc3630af7b3d98:a30a1a0b9bf5a559ef69e6dbee0b0fdd3762c6556d12dd31a012ab0546a54602:0279aee761678484aee392a8acba4201","risk_level":"safe","is_blocked":false,"safe_to_publish":true,"analysis_status":"ok","agent_auto_install_policy":"allowed","manual_install_policy":"allowed","summary":"I reviewed SKILL.md and found no evidence of malicious intent, prompt injection, data exfiltration, or executable payloads. All static findings are false positives caused by Markdown fences, inline code, dbt SQL/YAML examples, standard dbt CLI examples, and documentation URLs. No semantic security findings were identified.","remediation":[],"risk_factor_evidence":[{"factor":"external_commands","evidence":[{"file":"SKILL.md","line_end":31,"line_start":23},{"file":"SKILL.md","line_end":37,"line_start":31},{"file":"SKILL.md","line_end":37,"line_start":37},{"file":"SKILL.md","line_end":38,"line_start":38},{"file":"SKILL.md","line_end":39,"line_start":39},{"file":"SKILL.md","line_end":68,"line_start":43},{"file":"SKILL.md","line_end":70,"line_start":68},{"file":"SKILL.md","line_end":92,"line_start":70},{"file":"SKILL.md","line_end":98,"line_start":92},{"file":"SKILL.md","line_end":139,"line_start":98},{"file":"SKILL.md","line_end":143,"line_start":139},{"file":"SKILL.md","line_end":168,"line_start":143},{"file":"SKILL.md","line_end":170,"line_start":168},{"file":"SKILL.md","line_end":212,"line_start":170},{"file":"SKILL.md","line_end":216,"line_start":212},{"file":"SKILL.md","line_end":250,"line_start":216},{"file":"SKILL.md","line_end":254,"line_start":250},{"file":"SKILL.md","line_end":322,"line_start":254},{"file":"SKILL.md","line_end":324,"line_start":322},{"file":"SKILL.md","line_end":379,"line_start":324},{"file":"SKILL.md","line_end":383,"line_start":379},{"file":"SKILL.md","line_end":438,"line_start":383},{"file":"SKILL.md","line_end":442,"line_start":438},{"file":"SKILL.md","line_end":468,"line_start":442},{"file":"SKILL.md","line_end":472,"line_start":468},{"file":"SKILL.md","line_end":513,"line_start":472},{"file":"SKILL.md","line_end":517,"line_start":513},{"file":"SKILL.md","line_end":538,"line_start":517},{"file":"SKILL.md","line_end":551,"line_start":538}]},{"factor":"network","evidence":[{"file":"SKILL.md","line_end":558,"line_start":558},{"file":"SKILL.md","line_end":559,"line_start":559},{"file":"SKILL.md","line_end":560,"line_start":560},{"file":"SKILL.md","line_end":561,"line_start":561}]}],"critical_findings":[],"high_findings":[],"medium_findings":[],"low_findings":[],"dangerous_patterns":[],"files_scanned":1,"total_lines":562,"audit_model":"codex","audited_at":"2026-07-07T07:13:38.435+00:00","created_at":"2026-07-07T09:33:18.77612+00:00","static_findings":[{"id":"external_commands:SKILL.md:23:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":31,"severity":"medium","line_start":23},{"id":"external_commands:SKILL.md:31:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":37,"severity":"medium","line_start":31},{"id":"external_commands:SKILL.md:37:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"| Staging | `stg_` | `stg_stripe__payments` |","category":"external_commands","line_end":37,"severity":"medium","line_start":37},{"id":"external_commands:SKILL.md:38:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"| Intermediate | `int_` | `int_payments_pivoted` |","category":"external_commands","line_end":38,"severity":"medium","line_start":38},{"id":"external_commands:SKILL.md:39:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"| Marts | `dim_`, `fct_` | `dim_customers`, `fct_orders` |","category":"external_commands","line_end":39,"severity":"medium","line_start":39},{"id":"external_commands:SKILL.md:43:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```yaml","category":"external_commands","line_end":68,"severity":"medium","line_start":43},{"id":"external_commands:SKILL.md:68:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":70,"severity":"medium","line_start":68},{"id":"external_commands:SKILL.md:70:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":92,"severity":"medium","line_start":70},{"id":"external_commands:SKILL.md:92:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":98,"severity":"medium","line_start":92},{"id":"external_commands:SKILL.md:98:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```yaml","category":"external_commands","line_end":139,"severity":"medium","line_start":98},{"id":"external_commands:SKILL.md:139:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":143,"severity":"medium","line_start":139},{"id":"external_commands:SKILL.md:143:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```sql","category":"external_commands","line_end":168,"severity":"medium","line_start":143},{"id":"external_commands:SKILL.md:168:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":170,"severity":"medium","line_start":168},{"id":"external_commands:SKILL.md:170:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```sql","category":"external_commands","line_end":212,"severity":"medium","line_start":170},{"id":"external_commands:SKILL.md:212:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":216,"severity":"medium","line_start":212},{"id":"external_commands:SKILL.md:216:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```sql","category":"external_commands","line_end":250,"severity":"medium","line_start":216},{"id":"external_commands:SKILL.md:250:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":254,"severity":"medium","line_start":250},{"id":"external_commands:SKILL.md:254:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```sql","category":"external_commands","line_end":322,"severity":"medium","line_start":254},{"id":"external_commands:SKILL.md:322:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":324,"severity":"medium","line_start":322},{"id":"external_commands:SKILL.md:324:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```sql","category":"external_commands","line_end":379,"severity":"medium","line_start":324},{"id":"external_commands:SKILL.md:379:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":383,"severity":"medium","line_start":379},{"id":"external_commands:SKILL.md:383:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```yaml","category":"external_commands","line_end":438,"severity":"medium","line_start":383},{"id":"external_commands:SKILL.md:438:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":442,"severity":"medium","line_start":438},{"id":"external_commands:SKILL.md:442:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```sql","category":"external_commands","line_end":468,"severity":"medium","line_start":442},{"id":"external_commands:SKILL.md:468:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":472,"severity":"medium","line_start":468},{"id":"external_commands:SKILL.md:472:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```sql","category":"external_commands","line_end":513,"severity":"medium","line_start":472},{"id":"external_commands:SKILL.md:513:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":517,"severity":"medium","line_start":513},{"id":"external_commands:SKILL.md:517:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```bash","category":"external_commands","line_end":538,"severity":"medium","line_start":517},{"id":"external_commands:SKILL.md:538:ruby-shell-backtick-execution","file":"SKILL.md","pattern":"Ruby/shell backtick execution","snippet":"```","category":"external_commands","line_end":551,"severity":"medium","line_start":538},{"id":"network:SKILL.md:558:hardcoded-url","file":"SKILL.md","pattern":"Hardcoded URL","snippet":"- [dbt Documentation](https://docs.getdbt.com/)","category":"network","line_end":558,"severity":"low","line_start":558},{"id":"network:SKILL.md:559:hardcoded-url","file":"SKILL.md","pattern":"Hardcoded URL","snippet":"- [dbt Best Practices](https://docs.getdbt.com/guides/best-practices)","category":"network","line_end":559,"severity":"low","line_start":559},{"id":"network:SKILL.md:560:hardcoded-url","file":"SKILL.md","pattern":"Hardcoded URL","snippet":"- [dbt-utils Package](https://hub.getdbt.com/dbt-labs/dbt_utils/latest/)","category":"network","line_end":560,"severity":"low","line_start":560},{"id":"network:SKILL.md:561:hardcoded-url","file":"SKILL.md","pattern":"Hardcoded URL","snippet":"- [dbt Discourse](https://discourse.getdbt.com/)","category":"network","line_end":561,"severity":"low","line_start":561},{"id":"blocker:SKILL.md:116:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"- name: id","category":"blocker","line_end":117,"severity":"low","line_start":116},{"id":"blocker:SKILL.md:129:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"- name: id","category":"blocker","line_end":130,"severity":"low","line_start":129},{"id":"blocker:SKILL.md:133:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"- name: customer_id","category":"blocker","line_end":134,"severity":"low","line_start":133},{"id":"blocker:SKILL.md:138:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"field: id","category":"blocker","line_end":139,"severity":"low","line_start":138},{"id":"blocker:SKILL.md:152:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"id as customer_id,","category":"blocker","line_end":152,"severity":"low","line_start":152},{"id":"blocker:SKILL.md:191:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"id as payment_id,","category":"blocker","line_end":191,"severity":"low","line_start":191},{"id":"blocker:SKILL.md:235:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"group by customer_id","category":"blocker","line_end":236,"severity":"low","line_start":235},{"id":"blocker:SKILL.md:279:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"group by customer_id","category":"blocker","line_end":280,"severity":"low","line_start":279},{"id":"blocker:SKILL.md:375:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"left join customers on orders.customer_id = customers.customer_id","category":"blocker","line_end":375,"severity":"low","line_start":375},{"id":"blocker:SKILL.md:397:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"- name: customer_id","category":"blocker","line_end":398,"severity":"low","line_start":397},{"id":"blocker:SKILL.md:415:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"description: Total amount paid by customer","category":"blocker","line_end":415,"severity":"low","line_start":415},{"id":"blocker:SKILL.md:428:system-reconnaissance","file":"SKILL.md","pattern":"System reconnaissance","snippet":"- name: order_id","category":"blocker","line_end":429,"severity":"low","line_start":428}],"finding_verdicts":[{"id":"external_commands:SKILL.md:23:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:31:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:37:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:38:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:39:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:43:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:68:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:70:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:92:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:98:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:139:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:143:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:168:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:170:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:212:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:216:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:250:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:254:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:322:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:324:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:379:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:383:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:438:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:442:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:468:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:472:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:513:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"external_commands:SKILL.md:517:ruby-shell-backtick-execution","reason":"The lines are a fenced Markdown bash example showing normal dbt CLI commands for development, testing, documentation, and debugging. It is instructional text, not code executed by the skill.","verdict":"false_positive","confidence":0.91},{"id":"external_commands:SKILL.md:538:ruby-shell-backtick-execution","reason":"The match is a Markdown fence, inline code marker, or dbt SQL/YAML example. There is no Ruby backtick expression, shell invocation, or dynamic execution path in the skill.","verdict":"false_positive","confidence":0.96},{"id":"network:SKILL.md:558:hardcoded-url","reason":"The URL is a public dbt documentation or community resource link. There is no request logic, telemetry, secret transfer, or data exfiltration behavior in the skill.","verdict":"false_positive","confidence":0.95},{"id":"network:SKILL.md:559:hardcoded-url","reason":"The URL is a public dbt documentation or community resource link. There is no request logic, telemetry, secret transfer, or data exfiltration behavior in the skill.","verdict":"false_positive","confidence":0.95},{"id":"network:SKILL.md:560:hardcoded-url","reason":"The URL is a public dbt documentation or community resource link. There is no request logic, telemetry, secret transfer, or data exfiltration behavior in the skill.","verdict":"false_positive","confidence":0.95},{"id":"network:SKILL.md:561:hardcoded-url","reason":"The URL is a public dbt documentation or community resource link. There is no request logic, telemetry, secret transfer, or data exfiltration behavior in the skill.","verdict":"false_positive","confidence":0.95},{"id":"blocker:SKILL.md:116:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97},{"id":"blocker:SKILL.md:129:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97},{"id":"blocker:SKILL.md:133:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97},{"id":"blocker:SKILL.md:138:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97},{"id":"blocker:SKILL.md:152:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97},{"id":"blocker:SKILL.md:191:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97},{"id":"blocker:SKILL.md:235:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97},{"id":"blocker:SKILL.md:279:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97},{"id":"blocker:SKILL.md:375:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97},{"id":"blocker:SKILL.md:397:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97},{"id":"blocker:SKILL.md:415:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97},{"id":"blocker:SKILL.md:428:system-reconnaissance","reason":"The text is a database column name or SQL/YAML modeling example, such as id, customer_id, or group by customer_id. It is not host, user, network, or system reconnaissance.","verdict":"false_positive","confidence":0.97}],"semantic_findings":[],"subject_marketplace_commit_sha":null,"subject_content_hash":null,"subject_tree_hash":null,"subject_plugin_path":null,"audit_payload_hash":null,"confirmed_risk_level":null,"scanner_version":null,"policy_version":null,"subject":{"marketplaceCommitSha":null,"contentHash":null,"treeHash":null,"pluginPath":null,"auditPayloadHash":null},"scannerVersion":null,"policyVersion":null},"auditTranslation":null,"localization":{"requestedLocale":"en","contentLocale":"en","availableLocales":["en"],"fallbackToEnglish":false},"attestation":{"availability":"not_attestable","url":null,"status":null,"reason":"confirmed_risk_level does not match the canonical trust resolver"},"trust":{"publicState":"public","auditState":"complete","auditCurrentness":null,"confirmedRiskLevel":"safe","confirmedFindingCount":0,"capabilityReviewCount":0,"needsReviewCount":0,"falsePositiveCount":0,"agentAutoInstallPolicy":"allowed","manualInstallPolicy":"allowed","artifactSignatureState":"available","attestationState":"not_attestable","verificationState":"not_verified"},"isLatest":false}}