Sample Examples of How Zingle generated context looks like compared to Snowflake/Databricks
Database: Very popular Ride Hailing App with open source codebase. This is sample documentation of 5 columns of table Ride.
TableName: Ride:
Tracks ride lifecycle from driver assignment through completion, capturing GPS tracking, fare calculation, and driver-customer interactions.
| Column | Snowflake/Databricks Generated | Zingle AI (Process-Aware) |
|---|---|---|
| END_OTP | One-time password used to end a ride. | This system-generated one-time password is required to complete a ride. It is generated at ride start when trip category requires OTP verification. Exception values include null, which occurs when trip category (rental, inter-city, delivery rides) doesn't require OTP verification, ride has enableOtpLessRide enabled, or ride hasn't started yet. The column is referenced in ride completion verification workflows, OnUpdate events for ride status, and order completion notification flows. |
| FARE | The fare amount. | Final calculated fare amount is charged to customer after ride completion. It is set during ride completion process when fare calculation is performed based on actual trip metrics. Calculated from actual distance traveled, trip duration, waiting time, toll charges, and fare policy parameters through fare recalculation function that applies distance-based pricing, time charges, and additional fees. Exception values include null and estimated fare fallback, which occur when ride hasn't completed yet or when fare calculation fails or fare policy disables recomputation. The column is used by payment processing workflows, driver earnings calculations in ClickHouse, and ride completion notifications to customer platforms. |
| STATUS | The current status of the ride. | This system-generated column indicates the current state of the ride in its lifecycle and determines what actions can be performed. It is updated during ride state transitions including creation, start, completion, or cancellation. The status is derived from ride lifecycle events. Exception values include NEW (immediate rides ready to be started by driver), UPCOMING (scheduled rides waiting for start time), INPROGRESS (ride currently active with driver en route or at destination), COMPLETED (ride finished successfully), and CANCELLED (ride terminated before completion by driver, dashboard, or system). Data columns that use status include driver availability status (impacts onRide status), booking status (synchronized with ride status), fare calculation triggers (activated on COMPLETED status), and location tracking activation (active during INPROGRESS). |
| TOLL_CHARGES | Toll charges for a ride | This system-generated column stores total toll charges accumulated during the ride based on route intersections with toll gates. It is updated in real-time during ride when driver passes through toll entry/exit points detected by location tracking system. The calculation uses route geometry intersection with toll gate coordinates from toll detection service, utilizing GPS tracking data and route interpolation to detect toll crossings and calculate charges from toll gate master data. Source columns include route waypoints, toll gate coordinates, and driver location updates. Exception values include null and 0, where null occurs when ride does not pass through any toll roads or toll detection fails, and 0 occurs when toll gates are crossed but no charges apply or calculation errors happen. The column is used by fare_parameters.toll_charges, ride fare breakup toll components, and driver payout calculations for fare breakdowns and driver earnings computation. |
| TOLL_CONFIDENCE | The confidence level of the toll charge. | Indicates the accuracy of toll charge estimation for a ride route. It is populated when toll charges are calculated during ride completion processing. The value is derived from toll calculation algorithms that assess route accuracy and toll detection reliability, based on route analysis, toll plaza detection accuracy, and GPS tracking quality during the ride. Exception values include null, which occurs when toll calculation is not performed, route does not include toll roads, or toll detection confidence cannot be determined. No dependent columns found in the current codebase using toll_confidence for calculations. |