SESSION - AWS Glue DataBrew

SESSION

Returns in a new column a session identifier based on a window created by column names from "group by" and "order by" statements.

Parameters

  • sourceColumn – The name of an existing column.

  • units – A unit of measure for describe the session length. Valid values are MONTHS, YEARS, MILLISECONDS, QUARTERS, HOURS, MICROSECONDS, WEEKS, SECONDS, DAYS, and MINUTES.

  • value – The number of units to define the time period.

  • groupByColumns – A JSON-encoded string describing the "group by" columns.

  • orderByColumns – A JSON-encoded string describing the "order by" columns.

  • targetColumn – A name for the newly created column.

Example

{
    "Action": {
        "Operation": "SESSION",
        "Parameters": {
            "sourceColumn": "object number",
            "units": "MINUTES",
            "value": "10",
            "groupByColumns": "[\"is public domain\"]",
            "orderByColumns": "[\"dimensions\"]",
            "targetColumn": "object number_SESSION",
        }
    }
}