custom-criteria-audit

Validates semantic view components against user-defined natural language criteria.

Updated Jun 9, 2025
One-click install
npx skills add https://github.com/RajaPoseidon/snippets_repo --skill custom-criteria-audit-rajaposeidon
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: custom-criteria-audit
Source: https://github.com/RajaPoseidon/snippets_repo/tree/main/snowflake/skills/audit/custom_criteria
Command: npx skills add https://github.com/RajaPoseidon/snippets_repo --skill custom-criteria-audit-rajaposeidon

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Teams need to enforce organization-specific naming conventions, data type rules, and metadata standards on Snowflake semantic views, but built-in audits cannot cover every custom rule. This Skill lets users express validation rules in plain language and checks the semantic view against them. ## Core Features & Use Cases - Natural Language Rule Parsing: Converts free-form criteria like "all revenue metrics must contain 'revenue' in the name" into concrete validation checks. - Component-Level Inspection: Retrieves tables, columns, measures, time dimensions, and relationships from the semantic view YAML via semantic_view_get.py and flags violations. - Compliance Reporting: Presents per-criterion compliance rates, violation details with expected versus actual values, and prioritized recommendations. - Use Case: A data team requires every measure description to mention its aggregation function. The user enters that rule, the audit scans all measures, and reports which ones fail with fix suggestions. ## Quick Start Ask the assistant to run a custom criteria audit on your semantic view and provide rules such as "verify all date columns use DATE or TIMESTAMP data types".

Frequently Asked Questions about custom-criteria-audit

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I audit a semantic view with custom validation rules?▼

Select Custom Criteria from the audit menu and enter your rules in natural language, one per line or all at once. The audit parses each rule, scans the semantic view components, and reports compliance rates with specific violations.

What kinds of criteria can I check in a semantic model?▼

You can check naming patterns, data type validations, relationship requirements, metadata presence, and content format rules. Examples include requiring revenue in metric names or verifying date columns use DATE or TIMESTAMP types.

Does the custom criteria audit require a semantic view YAML file?▼

Yes, the audit reads components from a semantic model YAML file using the semantic_view_get.py script. You must have a defined semantic view before running the audit, typically created during semantic view setup.

How are custom audit results presented?▼

Results show each criterion as fully compliant, partially compliant, or non-compliant with a compliance percentage. Violations list the failing component, the issue, expected versus actual values, and recommendations with priority levels.

What are the limitations of natural language criteria validation?▼

Criteria must be translatable into checks against semantic view components like tables, columns, measures, and relationships. Rules about runtime query behavior or data values inside tables are outside the audit's scope.