This is the new Amazon CloudFormation Template Reference Guide. Please update your bookmarks and links. For help getting started with CloudFormation, see the Amazon CloudFormation User Guide.
AWS::QuickSight::DataSet JoinOperation
A transform operation that combines data from two sources based on specified join conditions.
Syntax
To declare this entity in your Amazon CloudFormation template, use the following syntax:
JSON
{ "Alias" :String, "LeftOperand" :TransformOperationSource, "LeftOperandProperties" :JoinOperandProperties, "OnClause" :String, "RightOperand" :TransformOperationSource, "RightOperandProperties" :JoinOperandProperties, "Type" :String}
YAML
Alias:StringLeftOperand:TransformOperationSourceLeftOperandProperties:JoinOperandPropertiesOnClause:StringRightOperand:TransformOperationSourceRightOperandProperties:JoinOperandPropertiesType:String
Properties
Alias-
Alias for this operation.
Required: Yes
Type: String
Minimum:
1Maximum:
64Update requires: No interruption
LeftOperand-
The left operand for the join operation.
Required: Yes
Type: TransformOperationSource
Update requires: No interruption
LeftOperandProperties-
Properties that control how the left operand's columns are handled in the join result.
Required: No
Type: JoinOperandProperties
Update requires: No interruption
OnClause-
The join condition that specifies how to match rows between the left and right operands.
Required: Yes
Type: String
Minimum:
1Maximum:
512Update requires: No interruption
RightOperand-
The right operand for the join operation.
Required: Yes
Type: TransformOperationSource
Update requires: No interruption
RightOperandProperties-
Properties that control how the right operand's columns are handled in the join result.
Required: No
Type: JoinOperandProperties
Update requires: No interruption
Type-
The type of join to perform, such as
INNER,LEFT,RIGHT, orOUTER.Required: Yes
Type: String
Allowed values:
INNER | OUTER | LEFT | RIGHTUpdate requires: No interruption