SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.DATALAYER_EVENTS WHERE eventCategory = 'Rebooking Interactions'AND eventAction = 'mmb.login.attempt' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.DATALAYER_EVENTS WHEREevent = 'ga_event' AND eventCategory = 'Rebooking Interactions' AND eventAction = 'mmb.onlineTicket.gygWidget.impression' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Rebooking Interactions'AND se_action = 'mmb.preTravelGuide.actionBtn.click' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Rebooking Interactions'AND se_action = 'rebooking.click' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.DATALAYER_EVENTS WHERE eventCategory = 'Rebooking Interactions'AND eventAction = 'rebooking.online_ticket.trip_type_tab.click' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
List of rebooking events