[Analytics Engineering] 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
- Previous message (by thread): [Wranglers] Now you can execute an Azure Function in response to a data change event Azure SQL DB Table
- Next message (by thread): [Wranglers] New Table Function RANGE_SESSIONIZE in Google BigQuery