JoinOperation - Amazon Quick Sight

JoinOperation

A transform operation that combines data from two sources based on specified join conditions.

Contents

Note

In the following list, the required parameters are described first.

Alias

Alias for this operation.

Type: String

Length Constraints: Minimum length of 1. Maximum length of 64.

Required: Yes

LeftOperand

The left operand for the join operation.

Type: TransformOperationSource object

Required: Yes

OnClause

The join condition that specifies how to match rows between the left and right operands.

Type: String

Length Constraints: Minimum length of 1. Maximum length of 512.

Required: Yes

RightOperand

The right operand for the join operation.

Type: TransformOperationSource object

Required: Yes

Type

The type of join to perform, such as INNER, LEFT, RIGHT, or OUTER.

Type: String

Valid Values: INNER | OUTER | LEFT | RIGHT

Required: Yes

LeftOperandProperties

Properties that control how the left operand's columns are handled in the join result.

Type: JoinOperandProperties object

Required: No

RightOperandProperties

Properties that control how the right operand's columns are handled in the join result.

Type: JoinOperandProperties object

Required: No

See Also

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