Join - AWS Glue

Join

Specifies a transform that joins two datasets into one dataset using a comparison phrase on the specified data property keys. You can use inner, outer, left, right, left semi, and left anti joins.

Contents

Columns

A list of the two columns to be joined.

Type: Array of JoinColumn objects

Array Members: Fixed number of 2 items.

Required: Yes

Inputs

The data inputs identified by their node names.

Type: Array of strings

Array Members: Fixed number of 2 items.

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

Required: Yes

JoinType

Specifies the type of join to be performed on the datasets.

Type: String

Valid Values: equijoin | left | right | outer | leftsemi | leftanti

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: