[Wranglers] New Table Function RANGE_SESSIONIZE in Google BigQuery

[Ali, Saqib]

Google published a blogpost about RANGE_SESSIONIZE and GAP_FILL Table
Functions aka Table-Valued Function (TVF) here:
https://cloud.google.com/blog/products/data-analytics/bigquery-sql-gets-time-windowing-and-gap-filling

GAP_FILL looks interesting. I will be trying that over the weekend.

On Tue, Mar 19, 2024 at 1:51 PM Ali, Saqib <docbook.xml at gmail.com> wrote:

> 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/20240321/7fc9e58b/attachment.htm>