Ali, Saqib docbook.xml at gmail.com

Tue Mar 19 20:51:27 UTC 2024

Google recently added a new Table Function called RANGE_SESSIONIZE to Google BigQuery. RANGE_SESSIONIZE allows you to sessionize temporal data. Timestamps from events that either meet or overlap form one session. I am using it to sessionize web site visits and the pages viewed in each session. Here is the sample query and data: https://qosf.com/sessionization-using-RANGE_SESSIONIZE-in-google-big-query.html

Looks interesting. I will post more as I discover more use cases for RANGE_SESSIONIZE .

Saqib



More information about the Wranglers mailing list