ledger-quality
description (verbatim frontmatter)
Data-quality checks over the REAL fleet-deploy ledger (`fact_fleet_deploy` in local Postgres, migration `crates/durable-store/migrations/postgres/ 008_fleet_deploy_ledger.sql`) — typed rows (Pydantic `LedgerRow` + a `DeployStatus` enum whose 6 members are the migration's own `CREATE TYPE deploy_status` values, enforced by a live drift test that re-parses the SQL at test time), pure-function invariant checks (all-terminal after a completed batch, unique (domain, wave), verified rows carry verified_at, skipped rows carry notes), and a thin psql-backed CLI (`uv run ledger-quality check`) for live runs. Use when auditing a deploy wave's ledger state after a batch, validating ledger rows from any non-Postgres source (fixtures, CSV export, a merge), or checking the ledger before a closeout report. Do NOT use to WRITE ledger rows (plugins/cwc-deploy/skills/fleet-expansion/ scripts/ledger.sh is the only writer) or for deploy step-log timing analytics (cwc-analytics-engineering's deploy-wave-analytics owns the wave logs).
summary
Data-quality checks over the REAL fleet-deploy ledger (`fact_fleet_deploy` in local Postgres, migration `crates/durable-store/migrations/postgres/ 008_fleet_deploy_ledger.sql`) — typed rows (Pydantic `LedgerRow` + a `DeployStatus` enum whose 6 members are the migration's own `CREATE TYPE deploy_s...
source
plugins/cwc-data-engineering/skills/ledger-quality/SKILL.md
provenance
created 2026-07-10 18:13:13 · JSON