Sessionize Function Example | Teradata Vantage - Example: How to Use Sessionize - Analytics Database

Every complete example in this document is available in a zip file that you can download. The zip file includes a SQL script file that creates the input tables for the examples. If you are reading this document on https://docs.teradata.com/, you can download the zip file from the attachment in the left sidebar.

Sessionize Input

Sessionize SQL Call

SELECT * FROM SESSIONIZE (
  ON sessionize_table PARTITION BY user_id ORDER BY clicktime
  USING
  TimeColumn ('clicktime')
  TimeOut (300)
  ClickLag (0.2)
) ORDER BY user_id, clicktime;

Sessionize Output

There’s a new session recorded for each user if time between their clicks was more than 5 minutes (300 seconds). For userid 80000, time between two clicks was less than 0.2 seconds, and therefore recorded in clicklag column as ‘t’ for True.