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, orOUTER.Type: String
Valid Values:
INNER | OUTER | LEFT | RIGHTRequired: 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: