engineering 10
- SCD type 2 in dbt with window functions only
- One licence-plate range, three datasets: reproducible sampling for a warehouse
- A human-in-the-loop agent with LangGraph interrupt()
- Cosine similarity is not a relevance score
- No source, no answer: enforcing citations in code, not in the prompt
- Turning a full snapshot feed into a change stream (and why you still need a heartbeat)
- The bug that made 169,000 good events "late"
- The offset ledger: never commit past an open window
- Dutch public holidays in SQL: a date dimension that's right even on 5 May 2016
- CI for a dbt project: every pull request builds the whole warehouse