[Wranglers] New Table Function RANGE_SESSIONIZE in Google BigQuery
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://analyticsengineering.net/pipermail/wranglers/attachments/20240319/de72cc3d/attachment.htm>
More information about the Wranglers
mailing list