Skip to content
Kumar Chandrachooda
Series

KC Star V4 — Data Governance

In reading order.

  • 5 parts
  • ≈ 21 min total
  • 5 published
Part 1 20 Sep 2025 4 min read

The Version Where the Warehouse Grew a Conscience

Through V3, KC Star assumed every number it was fed was true. V4 stops assuming - adding data quality scores, lineage, and performance monitoring so the warehouse can say how much it trusts its own data. Kicking off the data governance series.

Part 2 27 Oct 2025 4 min read

A Quality Score on Every Row

KC Star V4 puts a DataQualityScore on every dimension and fact, defaulting to a perfect 1.0 and downgrading only on evidence. Here is the opt-out philosophy, the assessment procedures behind it, and the one query that finds every row the warehouse doesn't quite trust.

Part 3 04 Dec 2025 5 min read

Two Ways to Remember Where a Fact Came From

KC Star V4 tracks lineage two incompatible ways depending on which build you run - a normalized FactLineage graph in the root file, a denormalized DataLineage string in the version folder. The fork is real, and it is a clean case study in when a graph pays and when a string is enough.

Part 4 11 Jan 2026 4 min read

Facts That Show Their Work

A stored number that can't explain itself is a number you can only trust. KC Star V4 promotes CalculationContext to JSONB and adds statistical columns to aggregates, so every fact carries a queryable record of the inputs and formula that produced it.

Part 5 14 Feb 2026 4 min read

One Compose File, Four Databases

KC Star's dev stack stands up PostgreSQL and SQL Server with the schema auto-loaded through V4, pgAdmin pre-wired to the servers, and one command to a working warehouse. Here is how the compose file, the init scripts, and the pgAdmin auto-registration fit together.