ROLLING_SUM - Amazon Glue DataBrew
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

ROLLING_SUM

Returns in a new column the rolling sum of values from a specified number of rows before to a specified number of rows after the current row in the specified column.

Parameters
  • sourceColumn – The name of an existing column.

    numRowsBefore – A number of rows before the current source row, representing the start of the window.

  • numRowsAfter – A number of rows after the current source row, representing the end of the window.

  • targetColumn – A name for the newly created column.

Example

{ "Action": { "Operation": "ROLLING_SUM", "Parameters": { "numRowsAfter": "10", "numRowsBefore": "10", "sourceColumn": "weight_kg", "targetColumn": "weight_kg_ROLLING_SUM" } } }