- reference to column containing Datetime values used to identify sessions.
- Numeric value to identify the length of the rolling timeframe that demarcates a session.
- Unit of measure for the length of the rolling timeframe.
window functionsother windowing,
group parameters can be applied. You can use the
order parameters to define the groups of records and the order of those records to which this transform is applied.
In the generated column, identifiers are assigned to each row based on the computed session to which the row data belongs. Session IDs begin at
1 and increment, within each group.
window value:SESSION(Timestamp, 1, hour) order:'Timestamp'
Output: Generates a new column, which contains session identifiers for groups of rows based on 1-hour segments.
window value:SESSION(col_ref, k_integer,unit_of_time) order: order_col [group: group_col]
|Required?||Data Type||Example Value|
|Yes||String literal. See below for list.|
D s snippet Examples
Example - Assign session identifiers to timestamped events