interface JoinOperationProperty

Language	Type name
.NET	`Amazon.CDK.AWS.QuickSight.CfnDataSet.JoinOperationProperty`
Go	`github.com/aws/aws-cdk-go/awscdk/v2/awsquicksight#CfnDataSet_JoinOperationProperty`
Java	`software.amazon.awscdk.services.quicksight.CfnDataSet.JoinOperationProperty`
Python	`aws_cdk.aws_quicksight.CfnDataSet.JoinOperationProperty`
TypeScript	`aws-cdk-lib` » `aws_quicksight` » `CfnDataSet` » `JoinOperationProperty`

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

Example

// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { aws_quicksight as quicksight } from 'aws-cdk-lib';
const joinOperationProperty: quicksight.CfnDataSet.JoinOperationProperty = {
  alias: 'alias',
  leftOperand: {
    transformOperationId: 'transformOperationId',

    // the properties below are optional
    columnIdMappings: [{
      sourceColumnId: 'sourceColumnId',
      targetColumnId: 'targetColumnId',
    }],
  },
  onClause: 'onClause',
  rightOperand: {
    transformOperationId: 'transformOperationId',

    // the properties below are optional
    columnIdMappings: [{
      sourceColumnId: 'sourceColumnId',
      targetColumnId: 'targetColumnId',
    }],
  },
  type: 'type',

  // the properties below are optional
  leftOperandProperties: {
    outputColumnNameOverrides: [{
      outputColumnName: 'outputColumnName',

      // the properties below are optional
      sourceColumnName: 'sourceColumnName',
    }],
  },
  rightOperandProperties: {
    outputColumnNameOverrides: [{
      outputColumnName: 'outputColumnName',

      // the properties below are optional
      sourceColumnName: 'sourceColumnName',
    }],
  },
};

Properties

Name	Type	Description
alias	`string`	Alias for this operation.
leftOperand	`IResolvable` `\|` `TransformOperationSourceProperty`	The left operand for the join operation.
onClause	`string`	The join condition that specifies how to match rows between the left and right operands.
rightOperand	`IResolvable` `\|` `TransformOperationSourceProperty`	The right operand for the join operation.
type	`string`	The type of join to perform, such as `INNER` , `LEFT` , `RIGHT` , or `OUTER` .
leftOperandProperties?	`IResolvable` `\|` `JoinOperandPropertiesProperty`	Properties that control how the left operand's columns are handled in the join result.
rightOperandProperties?	`IResolvable` `\|` `JoinOperandPropertiesProperty`	Properties that control how the right operand's columns are handled in the join result.