Open-Source FHIR –> OMOP Pipeline
Automated FHIR-to-OMOP translation beats manual dbt modeling, but lacks Fivetran's broader connector library.
Avalon is a healthcare data platform that generates realistic synthetic data across the full clinical ecosystem — EHRs, labs, claims, pharmacy, devices — and unifies it into standardized, queryable formats in BigQuery. Powered by Forge.
Free OMOP CDM views on BigQuery when healthcare researchers need PHI-free test data.
Healthcare researchers and data engineers building clinical integrations
Synthea · OHDSI · Healthcare Data Gateway
What is Avalon? Avalon is an end-to-end pipeline that turns Synthea-generated FHIR bundles into clean, documented, queryable tables in BigQuery — then layers OMOP CDM 5.4 views on top.
The output is published free on BigQuery Analytics Hub, where anyone with a GCP account can subscribe and query it directly.
Why? Researchers need realistic clinical data in standard formats (OMOP) without PHI concerns Engineers need FHIR data to build and test healthcare integrations Analysts need pre-normalized tables with documented schemas, not raw nested JSON
Automated FHIR-to-OMOP translation beats manual dbt modeling, but lacks Fivetran's broader connector library.
90x query cost reduction by flattening 459 nested FHIR fields to 15 columns.
Open-source synthetic monitoring with multi-backend support and API workflow chaining.
Claude Code skill integration is nice, but Faker already generates dirty data.
Yet another synthetic data tool when Faker and Mockaroo already exist.
First shared benchmark for bank statement parsers when real data is legally off-limits.