Skip to main content
Engineering, Backend, Data / ML

Unified Session for Analytical Events

October 12, 2023 / Global
Featured image for Unified Session for Analytical Events
Image
Figure 1: Session Lifecycle
Image
Figure 2: Unified session backend architecture
Image
Figure 3: Cookie push to mobile
New column for unified sessionOverwrite Existing column
Need to point queries to new columnNo change in current queries
Code change required for downstream tablesNo need for any change as Unified Session ID will flow seamlessly in place of current Session ID
Tables where old Session ID and Unified Session ID have one-to-many mapping will not be able to take this approachTables where Session ID and unified session ID have one-to-many mapping will have more rows
Staggered rollout is supported by creating parallel tablesNo support for staggered rollout as joining between tables on Session ID might break
Rollback is relatively easyCan’t do rollback, as the original Session ID is overwritten 
Image
Figure 4: Join failure post migrating query
Image
Figure 5: Session ID Migration data path
Harsh Desai

Harsh Desai

Harsh Desai is an Engineering Manager at Uber. He has extensive experience in building and optimizing distributed systems and data platforms.

Gaurav Yadav

Gaurav Yadav

Gaurav Yadav is a Senior Software Engineer on the Data Intelligence team. He is focused on making data reliable and transparent to producers and consumers. Earlier he worked on backend systems.

Sahil Jindal

Sahil Jindal

Sahil Jindal is a Senior Software Engineer on the Data Intelligence team, focusing on improving latency and reliability of data at Uber, with a background in backend systems.

Satyam Shubham

Satyam Shubham

Satyam Shubham is a Software Engineer on the XP Mobile team, focusing on experimentation to help Uber make data-driven decisions.

Mahip Jain

Mahip Jain

Mahip Jain is a Senior Software Engineer on the Fulfillment team, working on building a unified platform for all business verticals at Uber to develop their trip fulfillment flow.

Anshal Shukla

Anshal Shukla

Anshal Shukla is a Senior Staff Engineer on the Data Intelligence team. He is focused on systems that improve data reliability and simplify data consumption and production at Uber.

Ashok Varma

Ashok Varma

Ashok Varma is a Senior Software Engineer on the Mobile Network team, working on building a low latency, highly reliable mobile networking communication for Uber apps.

Posted by Harsh Desai, Gaurav Yadav, Sahil Jindal, Satyam Shubham, Mahip Jain, Anshal Shukla, Ashok Varma