Sessionize

Creates sessions for a clickstream data and also detects bots.

Options

ClickLag: Specifies the minimum number of seconds between clicks for the session user to be considered human. If clicks are more frequent, indicating that the user is a 'bot,' the function ignores the session. The min_human_click_lag must be less than session_timout. The data type of min_human_click_lag is DOUBLE PRECISION.
EmitNull: Specifies whether to output rows that have NULL values in their session id and rapid fire columns, even if their timestamp_column has a NULL value. The default value is 'false'.
Output Schema: Output Schema, if Volatile is true then use user login as the schema.
Output Table: Output Table
VAL Location: VAL Location
Volatile: Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.
TimeColumn: Specifies the name of the input column that contains the click times. Note: The timestamp_column must also be an order_column.
TimeOut: Specifies the number of seconds at which the session times out. If session_timeout seconds elapse after a click, then the next click starts a new session. The data type of session_timeout is DOUBLE PRECISION.