SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Booking Interactions'AND se_action = 'booking.misc.event.name' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.ECOMMERCE_EVENTS WHERE event_name = 'purchase' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Booking Interactions'AND se_action = 'booking.success.fun_fact.load' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Booking Interactions'AND se_action = 'booking.success.generate_passes.failed' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Booking Interactions'AND se_action = 'booking.welcome-account.clicked' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
List of Booking events