Flag each event as starting a new session

Per user, flag every event that starts a new session under the 30-minute gap rule: is_new_session = true if the gap since the previous event > 30 minutes OR if it's the user's first event. Otherwise false.

Sort by user_id then event_ts ascending.

Returnevent_iduser_idevent_tsis_new_session

Columns

sess_events5 columns

columntype

event_idVARCHAR

user_idVARCHAR

event_tsTIMESTAMP WITH TIME ZONE

event_typeVARCHAR

pageVARCHAR

The table

16 rows · 5 columns

sess_eventsfirst 5 of 16 rows

event_iduser_idevent_tsevent_typepage

ev_01u_a2026-06-01 10:00:00page_view/home

ev_02u_a2026-06-01 10:15:00page_view/products

ev_03u_a2026-06-01 10:25:00logout/products

ev_04u_a2026-06-01 10:30:00page_view/checkout

ev_05u_b2026-06-01 09:00:00page_view/landing

If you get stuck

Show hint · 1 hint Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows