Storing Webhook Events: JSON Blob vs Records (and the 30-day trap)
Providers delete webhook events after 30 days, and a JSON blob column can't be queried by customer or amount. Flatten the fields you filter on, keep the raw payload, dedupe on event ID.