Posts
All the articles I've posted.
-
CCLF is not eligibility: where dual status gets lost in Medicare ACO data
How a coalesce and a latest-month rule in Tuva's CCLF + ALR connectors can turn full-dual Medicare beneficiaries into non-duals in CMS-HCC.
-
COALESCE doesn't care what your columns mean
COALESCE checks types, not meaning. How merging columns with different semantics silently breaks data, and the dbt guardrails that catch it.
-
Triggering AWS Glue Jobs from EventBridge: Workflows, Scheduler, and the IAM You Actually Need
A Glue job isn't a native EventBridge rule target. Three working patterns (workflow, Scheduler, Step Functions) with the exact IAM each one needs.
-
Debugging AWS Glue Job Bookmarks Not Working as Expected
Glue job bookmarks fail silently: reprocessed data, skipped files, or no state at all. A checklist of the root causes and how to verify each one.
-
Where Agents Schema fits in a dbt → Snowflake → Looker pipeline
Agents Schema doesn't replace dbt, semantic views or LookML. It indexes them inside the warehouse for agents. Where it fits, what it costs, when to skip it.
-
Why Athena Returns No Rows on Partitioned Tables (and How to Fix It)
Your data is in S3, the table exists, and Athena returns zero rows. Six root causes behind partition metadata desync and how to diagnose each one.
-
Tuva's encounter grouper only groups claims. Here's what happens to your ADT encounters
Tuva's encounter grouper only runs on claims. Clinical ADT/EHR encounters are standardized and stacked in core.encounter, never matched or deduped.
-
Building an AI oracle slot machine with nothing but canvas
A zero-dependency slot machine that generates AI-doom prophecies, decided by a hand of blackjack, rendered as a downloadable PNG. One HTML file, one canvas element, no build step.