“How much of what we booked actually flew?”
Booked-to-flown gross weight is a cohort measure: confirmed booking pieces frozen at T-24h before original departure, compared with the gross mass that actually flew from the same pieces. Duodata connects that agreed definition to the shipment tables and deploys it as native semantics in Databricks or Snowflake.
For cargo operations and commercial teams · Cargo operations · Commercial planning · Finance
Booked-to-flown gross weight, defined precisely
The agreed cohort rule becomes an explicit mapping: which tables hold booking pieces and flown legs, how the original piece IDs join the cohort, and where the T-24h cutoff and measurement window are applied. That mapping deploys as a Unity Catalog metric view or a Snowflake semantic view — in your account, your Git and your release process.
| Business term | Source | Note |
|---|---|---|
| Booked gross mass | cargo.booking_pieces | Gross freight mass of distinct confirmed pieces, frozen at T-24h before original departure (UTC). |
| Flown gross mass | cargo flight legs | Actual gross mass flown, linked via original piece IDs, counted once per route segment. |
| Cohort cutoff | booking status at T-24h | Cancelled and waitlisted bookings excluded at the cutoff; original departure assignment preserved. |
| Measurement window | departure timestamp | Original departure vs 48-hour window — an explicit, owned definition change. |
- Observed schema of booking-piece and flight-leg tables, kept distinct from the business definition
- Business-term mapping: booked gross mass, flown gross mass, cohort cutoff, window → physical columns
- Native output: metric view (Databricks) or semantic view (Snowflake)
- Rule changes reviewed once, then carried through with lineage
Illustrative mapping with fictional tables. Website examples do not execute in your warehouse.
Put this meaning to work in your platform.
Databricks
The agreed definition deploys as Unity Catalog metric views, answered by AI/BI Genie.
Snowflake
The agreed definition deploys as Semantic Views, answered by Cortex Analyst.
Start a free pilot
We work through one business question with you: agree its meaning, map it to the relevant data and review how it works on Snowflake or Databricks. We agree the scope together before we start.
- 01One business question
- 02One owner of the definition
- 03The data it depends on
- 04A review on your platform
- Start a free pilotWatch demo