Aggregate - AWS Glue

Aggregate

Specifies a transform that groups rows by chosen fields and computes the aggregated value by specified function.

Contents

Aggs

Specifies the aggregate functions to be performed on specified fields.

Type: Array of AggregateOperation objects

Array Members: Minimum number of 1 item. Maximum number of 30 items.

Required: Yes

Groups

Specifies the fields to group by.

Type: Array of arrays of strings

Pattern: ([\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF]|[^\S\r\n"'])*

Required: Yes

Inputs

Specifies the fields and rows to use as inputs for the aggregate transform.

Type: Array of strings

Array Members: Fixed number of 1 item.

Pattern: [A-Za-z0-9_-]*

Required: Yes

Name

The name of the transform node.

Type: String

Pattern: ([\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF]|[^\r\n])*

Required: Yes

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following: