Preparing chapter
Loading your data design lesson
The curriculum shell is ready while the requested chapter is being prepared. You can wait here or return to the design library.
Preparing chapter
The curriculum shell is ready while the requested chapter is being prepared. You can wait here or return to the design library.
WhatsApp · Big Data Engineering · Explicit grains, reusable joins
Connect privacy-safe dimensions to message, delivery, group, media, call, status, notification, experiment, and regional-capacity facts without mixing logical events with device fan-out.
WhatsApp analytical model
Hover, focus, or tap any table to highlight its warehouse joins and explain its exact row grain, contents, source, and WhatsApp use.
Fact table explanation
One row means
One row represents one logical message × one eligible recipient device.
Key contents
Message ID, protected recipient-device key, accepted, routed, delivered and read times, retry count, status, latency, and failure reason.
How WhatsApp uses it
Measures device-level delivery success and latency without confusing one logical message with its multi-device fan-out.
Created from
Reconciled from messaging acceptance, routing, delivery, read, device, and group-membership evidence using event-time rules.
TRANSACTION FACTS
Immutable business events such as a message, call, transfer, view, or exposure.
ACCUMULATING LIFECYCLE
Delivery milestones are curated for latency queries while raw transitions remain immutable.
PERIODIC SNAPSHOT
Regional capacity is frozen every five minutes for planning and incident correlation.
