What problem does it solve? Static checks on committed SQL cannot prove that a materialized warehouse table is actually correct. This Skill runs the live database checks that only a running Postgres can answer — primary key uniqueness, date dimension coverage, foreign key orphans, and silver-to-gold reconciliation — and interprets each finding so you know exactly where to fix it. ## Core Features & Use Cases - Live validation run: Executes retail validate against a materialized silver/gold table using a reviewed source map, with a read-only, host-agnostic Postgres connection. - Finding interpretation: Maps each finding id (V-RC2, V-RC15, V-RC16 orphan, V-RC16 reconcile) to its meaning and the exact place to fix it, from silver SQL grain fixes to gold aggregation corrections. - Deferred-mode reporting: When no DSN or db extra is configured, reports the enable steps instead of faking a pass. - Use Case: After building silver and gold layers for a retail sales table, ask the agent to validate the table; it runs the live checks, reports a V-RC16 orphan finding with its locator, and directs you to fix the FK COALESCE to the -1 unknown member. ## Quick Start Ask the agent to validate the materialized retail table using its source map and interpret any findings it reports.
