DuckDB normalizes FDA drug JSON, slashing query time and memory
By extracting high‑cardinality JSON fields like pharm_class_epc into a separate lookup table and indexing them with integer IDs, DuckDB turned a 480 GB FDA drug event dump from painfully slow scans into instant queries. Data engineers can now handle massive healthcare JSON datasets efficiently, cutting memory use and query time dramatically.