Articles

Browse my articles and working papers below.

Building FlowProxy: a dbt Semantic Layer that BI tools can actually reach

How I built a self-hosted semantic proxy over dbt-core and MetricFlow that speaks the PostgreSQL wire protocol, so Amazon QuickSight and LLM agents can query governed metrics with the guardrails in the YAML enforced automatically. Covers the wire-protocol emulation, the semi-additive guardrail proof, auto-cube exploration, an embedded MCP server, an air-gapped CI/CD deploy model with blue/green manifest hot-swap, and the nine bugs it took to get a live QuickSight demo on AWS working end to end.

Jul 6, 2026

Keeping AI Spend Flat While Token Usage Grows Exponentially

A practical guide to routing, caching, and semantic context for DBT/SQL/Airflow teams. Covers a local routing classifier, prefix-cache-friendly prompt construction, and treating the DBT semantic layer as a retrieval index instead of a document to paste, with instrumentation that lets Power BI track cost per token rather than absolute spend.

Jun 28, 2026

PageRank as a Popularity Contest: Structural Vulnerabilities, Collusion Dynamics, and a Byzantine Fault-Tolerant Alternative

A formal critique of PageRank as an inter-subjective popularity contest incapable of surfacing marginal truth, with a proof of collusion-susceptibility for O(log N) coalitions, analysis of the institutional epistemic loop, and a proposed BFT TruthChain architecture combining independence-weighted citation scoring, Brier-anchored content quality functions, and adversarial audit governance as a collusion-resistant retrieval alternative.

Feb 22, 2026