spot-check-features

Validate ML feature store data quality with SQL checks on BigQuery tables.

1|Updated May 24, 2025
One-click install
npx skills add https://github.com/najicham/nba-stats-scraper --skill spot-check-features
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: spot-check-features
Source: https://github.com/najicham/nba-stats-scraper/tree/main/.claude/skills/spot-check-features
Command: npx skills add https://github.com/najicham/nba-stats-scraper --skill spot-check-features

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps data teams detect and validate data quality issues in the ML feature store before model training, reducing the risk of training on dirty data.

Core Features & Use Cases

  • Feature store quality checks: validates readiness and alert levels across recent data slices.
  • Comprehensive metrics: tracks per-date quality metrics such as matchup_quality_pct, vegas_quality_pct, and feature_count completeness.
  • Operational validation: provides SQL templates and dashboards to identify data quality regressions and guide remediation.

Quick Start

Run the validation against the last 7 days of feature data to surface quality readiness and alert levels. Example queries can be executed with your data warehouse client to reproduce checks for is_quality_ready, quality_alert_level, and feature_count completeness, and to surface actionable remediation guidance.

Frequently Asked Questions about spot-check-features

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

FAQPage Schema
How do I validate feature store data quality before ML model training?

To validate ML feature store data quality before training, apply SQL-based checks to BigQuery tables tracking is_quality_ready, quality_alert_level, and feature_count completeness. This surfaces data quality issues across daily batches to ensure models train on clean data.

What metrics should I track for daily batch ML feature validation?

Track per-date quality metrics such as matchup_quality_pct, vegas_quality_pct, and feature_count completeness against game_date slices. These metrics detect data quality regressions and readiness across recent batches to guide remediation.

Can I use SQL queries to check BigQuery feature store readiness for the last 7 days?

Yes, you can execute SQL queries against BigQuery tables to check feature store readiness for the last 7 to 14 days. Validate is_quality_ready flags, quality_alert_level, and feature_count to surface actionable remediation guidance for your data warehouse.

What is the best way to detect data quality regressions in an ML feature store?

The best way to detect data quality regressions in an ML feature store is running structured SQL evaluations on daily batches. Comparing per-day quality metrics and alert levels across 7 to 14 day slices identifies readiness drops and guides immediate remediation.

Do I need specific BigQuery table fields for ML data pipeline validation?

Yes, ML data pipeline validation requires specific BigQuery fields including is_quality_ready, quality_alert_level, feature_count, feature_quality_score, and game_date. These fields are necessary to produce structured evaluations and remediation guidance for daily feature batches.