brady_bastian

Parsing FHIR data and converting that to OMOP standard is a notoriously difficult problem. I think we've cracked it. I've open sourced two GitHub repos: 1. Forge-Core. This is the secret sauce. Automatically parse ANY…

Automatically decompose nested JSON in your data warehouse into normalized dbt models. Forge Core is a deterministic BFS engine that reads a single JSON column (or multi-column table), discovers all nested structures,…

Avalon Synthetic clinical data pipeline — generate realistic FHIR R4 patient data, normalize it through Forge, and query it as OMOP CDM 5.4 views. What is Avalon? Avalon is an end-to-end pipeline that turns…

We generated ~1,100 synthetic patients with Synthea, processed the FHIR R4 output through our normalization engine (Forge), and published it as a free public dataset on BigQuery Analytics Hub. 8 resource types: Patient,…

https://forge.foxtrotcommunications.net/ I've been a data engineer for years and one thing drove me crazy: every time we integrated a new API, someone had to manually write SQL to flatten the JSON into tables. LATERAL…

I've built a product that completely parses highly nested JSON data in cloud data warehouses. Forge works by methodically dissecting each subcollection and each field of Json data, one by one, and creates 3NF tables for…