skills.rest
randoneering
randoneeringCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

vqr-testing-audit

Audit VQRs by evaluating semantic views for accuracy without VQR hints.

Updated Mar 7, 2026
Search Tags:#testing#audit#evaluation#sql#semantic-view#cortex#vqr
One-click install
npx skills add https://github.com/randoneering/nix-flake-mirror --skill vqr-testing-audit
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: vqr-testing-audit
Source: https://github.com/randoneering/nix-flake-mirror/tree/main/home/programs/opencode/skills/snowflake/semantic-view-optimization/audit/vqr_testing
Command: npx skills add https://github.com/randoneering/nix-flake-mirror --skill vqr-testing-audit

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The VQR auditing skill helps teams verify semantic view accuracy by systematically evaluating verified queries in the absence of VQR hints, exposing gaps in coverage and logic.

Core Features & Use Cases

  • End-to-end VQR audit workflow: extraction, evaluation, and results formatting to determine pass/fail status.
  • Enforces mandatory checkpoints and parallelized tool calls to scale across multiple VQRs.
  • Clear, actionable results per VQR with ground truth SQL, generated SQL, and comparison outcomes to guide debugging and improvements.

Quick Start

Select VQRs to audit from the VQR Extraction step and start the audit workflow.

Frequently Asked Questions about vqr-testing-audit

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

FAQPage Schema
How do I audit semantic views without using VQR hints?▼

You can audit semantic views without VQR hints by systematically evaluating verified queries end-to-end, covering extraction, evaluation, and results formatting to determine pass/fail status.

What is the best way to compare ground truth SQL against generated SQL for VQR testing?▼

The best way to compare SQL for VQR testing is to run an automated audit workflow that outputs clear, actionable results showing ground truth SQL, generated SQL, and comparison outcomes side-by-side.

How do I scale VQR evaluation across multiple semantic views efficiently?▼

You scale VQR evaluation across multiple semantic views by enforcing automated task orchestration with parallelized tool calls and mandatory checkpoints throughout the audit workflow.

Does VQR testing work without dependency components for automated orchestration?▼

Yes, VQR testing works without external dependencies by applying automated task orchestration and parallel tool calls natively within the workflow to manage extraction and evaluation.

Why does my semantic view evaluation fail during VQR extraction and formatting?▼

Semantic view evaluation fails during VQR extraction and formatting when gaps in logic or coverage exist, which the audit exposes by comparing generated SQL against ground truth SQL.

When do I need to run an end-to-end VQR audit on my semantic views?▼

You need to run an end-to-end VQR audit on your semantic views when you want to systematically verify accuracy, expose coverage gaps, and debug logic errors using actionable comparison outcomes.

Related Skills

Explore More Data & Analytics Skills→
NAKKA-KNAKKA-K

eval-driven-development

Define rubrics, run baseline evaluations, and compare before-and-after outcomes.

Community
Advanced
randoneeringrandoneering

semantic-view-optimization-validation

Compare generated SQL execution results against ground-truth SQL with exact-match validation.

Community
Advanced
sorodriguezzsorodriguezz

How InterSystems IRIS Processes SQL Statements

Detail the internal SQL statement processing pipeline in InterSystems IRIS.

Community
Intermediate
ValenBorrasValenBorras
1

eval-harness

Create repeatable evaluation frameworks for Claude Code sessions with pass/fail criteria.

Community
Advanced