Skip to content
v2.277.0

DataPrepConfigurationProperty Struct ​

Configuration for data preparation operations, defining the complete pipeline from source tables through transformations to destination tables.

Example ​

ts
// 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 dataPrepConfigurationProperty: quicksight.CfnDataSet.DataPrepConfigurationProperty = {
  destinationTableMap: {
    destinationTableMapKey: {
      alias: 'alias',
      source: {
        transformOperationId: 'transformOperationId',
      },
    },
  },
  sourceTableMap: {
    sourceTableMapKey: {
      dataSet: {
        dataSetArn: 'dataSetArn',
        inputColumns: [{
          name: 'name',
          type: 'type',

          // the properties below are optional
          id: 'id',
          subType: 'subType',
        }],
      },
      physicalTableId: 'physicalTableId',
    },
  },
  transformStepMap: {
    transformStepMapKey: {
      aggregateStep: {
        aggregations: [{
          aggregationFunction: {
            listAggregation: {
              distinct: false,
              separator: 'separator',

              // the properties below are optional
              inputColumnName: 'inputColumnName',
            },
            percentileAggregation: {
              percentileValue: 123,

              // the properties below are optional
              inputColumnName: 'inputColumnName',
            },
            simpleAggregation: {
              functionType: 'functionType',

              // the properties below are optional
              inputColumnName: 'inputColumnName',
            },
          },
          newColumnId: 'newColumnId',
          newColumnName: 'newColumnName',
        }],
        alias: 'alias',
        source: {
          transformOperationId: 'transformOperationId',

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

        // the properties below are optional
        groupByColumnNames: ['groupByColumnNames'],
      },
      appendStep: {
        alias: 'alias',
        appendedColumns: [{
          columnName: 'columnName',
          newColumnId: 'newColumnId',
        }],

        // the properties below are optional
        firstSource: {
          transformOperationId: 'transformOperationId',

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

          // the properties below are optional
          columnIdMappings: [{
            sourceColumnId: 'sourceColumnId',
            targetColumnId: 'targetColumnId',
          }],
        },
      },
      castColumnTypesStep: {
        alias: 'alias',
        castColumnTypeOperations: [{
          columnName: 'columnName',
          newColumnType: 'newColumnType',

          // the properties below are optional
          format: 'format',
          subType: 'subType',
        }],
        source: {
          transformOperationId: 'transformOperationId',

          // the properties below are optional
          columnIdMappings: [{
            sourceColumnId: 'sourceColumnId',
            targetColumnId: 'targetColumnId',
          }],
        },
      },
      createColumnsStep: {
        columns: [{
          columnId: 'columnId',
          columnName: 'columnName',
          expression: 'expression',
        }],

        // the properties below are optional
        alias: 'alias',
        source: {
          transformOperationId: 'transformOperationId',

          // the properties below are optional
          columnIdMappings: [{
            sourceColumnId: 'sourceColumnId',
            targetColumnId: 'targetColumnId',
          }],
        },
      },
      filtersStep: {
        alias: 'alias',
        filterOperations: [{
          conditionExpression: 'conditionExpression',
          dateFilterCondition: {
            columnName: 'columnName',
            comparisonFilterCondition: {
              operator: 'operator',

              // the properties below are optional
              value: {
                staticValue: 'staticValue',
              },
            },
            rangeFilterCondition: {
              includeMaximum: false,
              includeMinimum: false,
              rangeMaximum: {
                staticValue: 'staticValue',
              },
              rangeMinimum: {
                staticValue: 'staticValue',
              },
            },
          },
          numericFilterCondition: {
            columnName: 'columnName',
            comparisonFilterCondition: {
              operator: 'operator',

              // the properties below are optional
              value: {
                staticValue: 123,
              },
            },
            rangeFilterCondition: {
              includeMaximum: false,
              includeMinimum: false,
              rangeMaximum: {
                staticValue: 123,
              },
              rangeMinimum: {
                staticValue: 123,
              },
            },
          },
          stringFilterCondition: {
            columnName: 'columnName',
            comparisonFilterCondition: {
              operator: 'operator',

              // the properties below are optional
              value: {
                staticValue: 'staticValue',
              },
            },
            listFilterCondition: {
              operator: 'operator',

              // the properties below are optional
              values: {
                staticValues: ['staticValues'],
              },
            },
          },
        }],
        source: {
          transformOperationId: 'transformOperationId',

          // the properties below are optional
          columnIdMappings: [{
            sourceColumnId: 'sourceColumnId',
            targetColumnId: 'targetColumnId',
          }],
        },
      },
      importTableStep: {
        alias: 'alias',
        source: {
          sourceTableId: 'sourceTableId',

          // the properties below are optional
          columnIdMappings: [{
            sourceColumnId: 'sourceColumnId',
            targetColumnId: 'targetColumnId',
          }],
        },
      },
      joinStep: {
        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',
          }],
        },
      },
      pivotStep: {
        alias: 'alias',
        pivotConfiguration: {
          pivotedLabels: [{
            labelName: 'labelName',
            newColumnId: 'newColumnId',
            newColumnName: 'newColumnName',
          }],

          // the properties below are optional
          labelColumnName: 'labelColumnName',
        },
        source: {
          transformOperationId: 'transformOperationId',

          // the properties below are optional
          columnIdMappings: [{
            sourceColumnId: 'sourceColumnId',
            targetColumnId: 'targetColumnId',
          }],
        },
        valueColumnConfiguration: {
          aggregationFunction: {
            listAggregation: {
              distinct: false,
              separator: 'separator',

              // the properties below are optional
              inputColumnName: 'inputColumnName',
            },
            percentileAggregation: {
              percentileValue: 123,

              // the properties below are optional
              inputColumnName: 'inputColumnName',
            },
            simpleAggregation: {
              functionType: 'functionType',

              // the properties below are optional
              inputColumnName: 'inputColumnName',
            },
          },
        },

        // the properties below are optional
        groupByColumnNames: ['groupByColumnNames'],
      },
      projectStep: {
        alias: 'alias',
        projectedColumns: ['projectedColumns'],
        source: {
          transformOperationId: 'transformOperationId',

          // the properties below are optional
          columnIdMappings: [{
            sourceColumnId: 'sourceColumnId',
            targetColumnId: 'targetColumnId',
          }],
        },
      },
      renameColumnsStep: {
        alias: 'alias',
        renameColumnOperations: [{
          columnName: 'columnName',
          newColumnName: 'newColumnName',
        }],
        source: {
          transformOperationId: 'transformOperationId',

          // the properties below are optional
          columnIdMappings: [{
            sourceColumnId: 'sourceColumnId',
            targetColumnId: 'targetColumnId',
          }],
        },
      },
      unpivotStep: {
        alias: 'alias',
        columnsToUnpivot: [{
          columnName: 'columnName',
          newValue: 'newValue',
        }],
        source: {
          transformOperationId: 'transformOperationId',

          // the properties below are optional
          columnIdMappings: [{
            sourceColumnId: 'sourceColumnId',
            targetColumnId: 'targetColumnId',
          }],
        },
        unpivotedLabelColumnId: 'unpivotedLabelColumnId',
        unpivotedLabelColumnName: 'unpivotedLabelColumnName',
        unpivotedValueColumnId: 'unpivotedValueColumnId',
        unpivotedValueColumnName: 'unpivotedValueColumnName',
      },
    },
  },
};
python
# The code below shows an example of how to instantiate this type.
# The values are placeholders you should change.
from aws_cdk import aws_quicksight as quicksight

data_prep_configuration_property = quicksight.CfnDataSet.DataPrepConfigurationProperty(
    destination_table_map={
        "destination_table_map_key": quicksight.CfnDataSet.DestinationTableProperty(
            alias="alias",
            source=quicksight.CfnDataSet.DestinationTableSourceProperty(
                transform_operation_id="transformOperationId"
            )
        )
    },
    source_table_map={
        "source_table_map_key": quicksight.CfnDataSet.SourceTableProperty(
            data_set=quicksight.CfnDataSet.ParentDataSetProperty(
                data_set_arn="dataSetArn",
                input_columns=[quicksight.CfnDataSet.InputColumnProperty(
                    name="name",
                    type="type",

                    # the properties below are optional
                    id="id",
                    sub_type="subType"
                )]
            ),
            physical_table_id="physicalTableId"
        )
    },
    transform_step_map={
        "transform_step_map_key": quicksight.CfnDataSet.TransformStepProperty(
            aggregate_step=quicksight.CfnDataSet.AggregateOperationProperty(
                aggregations=[quicksight.CfnDataSet.AggregationProperty(
                    aggregation_function=quicksight.CfnDataSet.DataPrepAggregationFunctionProperty(
                        list_aggregation=quicksight.CfnDataSet.DataPrepListAggregationFunctionProperty(
                            distinct=False,
                            separator="separator",

                            # the properties below are optional
                            input_column_name="inputColumnName"
                        ),
                        percentile_aggregation=quicksight.CfnDataSet.DataPrepPercentileAggregationFunctionProperty(
                            percentile_value=123,

                            # the properties below are optional
                            input_column_name="inputColumnName"
                        ),
                        simple_aggregation=quicksight.CfnDataSet.DataPrepSimpleAggregationFunctionProperty(
                            function_type="functionType",

                            # the properties below are optional
                            input_column_name="inputColumnName"
                        )
                    ),
                    new_column_id="newColumnId",
                    new_column_name="newColumnName"
                )],
                alias="alias",
                source=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                ),

                # the properties below are optional
                group_by_column_names=["groupByColumnNames"]
            ),
            append_step=quicksight.CfnDataSet.AppendOperationProperty(
                alias="alias",
                appended_columns=[quicksight.CfnDataSet.AppendedColumnProperty(
                    column_name="columnName",
                    new_column_id="newColumnId"
                )],

                # the properties below are optional
                first_source=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                ),
                second_source=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                )
            ),
            cast_column_types_step=quicksight.CfnDataSet.CastColumnTypesOperationProperty(
                alias="alias",
                cast_column_type_operations=[quicksight.CfnDataSet.CastColumnTypeOperationProperty(
                    column_name="columnName",
                    new_column_type="newColumnType",

                    # the properties below are optional
                    format="format",
                    sub_type="subType"
                )],
                source=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                )
            ),
            create_columns_step=quicksight.CfnDataSet.CreateColumnsOperationProperty(
                columns=[quicksight.CfnDataSet.CalculatedColumnProperty(
                    column_id="columnId",
                    column_name="columnName",
                    expression="expression"
                )],

                # the properties below are optional
                alias="alias",
                source=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                )
            ),
            filters_step=quicksight.CfnDataSet.FiltersOperationProperty(
                alias="alias",
                filter_operations=[quicksight.CfnDataSet.FilterOperationProperty(
                    condition_expression="conditionExpression",
                    date_filter_condition=quicksight.CfnDataSet.DataSetDateFilterConditionProperty(
                        column_name="columnName",
                        comparison_filter_condition=quicksight.CfnDataSet.DataSetDateComparisonFilterConditionProperty(
                            operator="operator",

                            # the properties below are optional
                            value=quicksight.CfnDataSet.DataSetDateFilterValueProperty(
                                static_value="staticValue"
                            )
                        ),
                        range_filter_condition=quicksight.CfnDataSet.DataSetDateRangeFilterConditionProperty(
                            include_maximum=False,
                            include_minimum=False,
                            range_maximum=quicksight.CfnDataSet.DataSetDateFilterValueProperty(
                                static_value="staticValue"
                            ),
                            range_minimum=quicksight.CfnDataSet.DataSetDateFilterValueProperty(
                                static_value="staticValue"
                            )
                        )
                    ),
                    numeric_filter_condition=quicksight.CfnDataSet.DataSetNumericFilterConditionProperty(
                        column_name="columnName",
                        comparison_filter_condition=quicksight.CfnDataSet.DataSetNumericComparisonFilterConditionProperty(
                            operator="operator",

                            # the properties below are optional
                            value=quicksight.CfnDataSet.DataSetNumericFilterValueProperty(
                                static_value=123
                            )
                        ),
                        range_filter_condition=quicksight.CfnDataSet.DataSetNumericRangeFilterConditionProperty(
                            include_maximum=False,
                            include_minimum=False,
                            range_maximum=quicksight.CfnDataSet.DataSetNumericFilterValueProperty(
                                static_value=123
                            ),
                            range_minimum=quicksight.CfnDataSet.DataSetNumericFilterValueProperty(
                                static_value=123
                            )
                        )
                    ),
                    string_filter_condition=quicksight.CfnDataSet.DataSetStringFilterConditionProperty(
                        column_name="columnName",
                        comparison_filter_condition=quicksight.CfnDataSet.DataSetStringComparisonFilterConditionProperty(
                            operator="operator",

                            # the properties below are optional
                            value=quicksight.CfnDataSet.DataSetStringFilterValueProperty(
                                static_value="staticValue"
                            )
                        ),
                        list_filter_condition=quicksight.CfnDataSet.DataSetStringListFilterConditionProperty(
                            operator="operator",

                            # the properties below are optional
                            values=quicksight.CfnDataSet.DataSetStringListFilterValueProperty(
                                static_values=["staticValues"]
                            )
                        )
                    )
                )],
                source=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                )
            ),
            import_table_step=quicksight.CfnDataSet.ImportTableOperationProperty(
                alias="alias",
                source=quicksight.CfnDataSet.ImportTableOperationSourceProperty(
                    source_table_id="sourceTableId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                )
            ),
            join_step=quicksight.CfnDataSet.JoinOperationProperty(
                alias="alias",
                left_operand=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                ),
                on_clause="onClause",
                right_operand=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                ),
                type="type",

                # the properties below are optional
                left_operand_properties=quicksight.CfnDataSet.JoinOperandPropertiesProperty(
                    output_column_name_overrides=[quicksight.CfnDataSet.OutputColumnNameOverrideProperty(
                        output_column_name="outputColumnName",

                        # the properties below are optional
                        source_column_name="sourceColumnName"
                    )]
                ),
                right_operand_properties=quicksight.CfnDataSet.JoinOperandPropertiesProperty(
                    output_column_name_overrides=[quicksight.CfnDataSet.OutputColumnNameOverrideProperty(
                        output_column_name="outputColumnName",

                        # the properties below are optional
                        source_column_name="sourceColumnName"
                    )]
                )
            ),
            pivot_step=quicksight.CfnDataSet.PivotOperationProperty(
                alias="alias",
                pivot_configuration=quicksight.CfnDataSet.PivotConfigurationProperty(
                    pivoted_labels=[quicksight.CfnDataSet.PivotedLabelProperty(
                        label_name="labelName",
                        new_column_id="newColumnId",
                        new_column_name="newColumnName"
                    )],

                    # the properties below are optional
                    label_column_name="labelColumnName"
                ),
                source=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                ),
                value_column_configuration=quicksight.CfnDataSet.ValueColumnConfigurationProperty(
                    aggregation_function=quicksight.CfnDataSet.DataPrepAggregationFunctionProperty(
                        list_aggregation=quicksight.CfnDataSet.DataPrepListAggregationFunctionProperty(
                            distinct=False,
                            separator="separator",

                            # the properties below are optional
                            input_column_name="inputColumnName"
                        ),
                        percentile_aggregation=quicksight.CfnDataSet.DataPrepPercentileAggregationFunctionProperty(
                            percentile_value=123,

                            # the properties below are optional
                            input_column_name="inputColumnName"
                        ),
                        simple_aggregation=quicksight.CfnDataSet.DataPrepSimpleAggregationFunctionProperty(
                            function_type="functionType",

                            # the properties below are optional
                            input_column_name="inputColumnName"
                        )
                    )
                ),

                # the properties below are optional
                group_by_column_names=["groupByColumnNames"]
            ),
            project_step=quicksight.CfnDataSet.ProjectOperationProperty(
                alias="alias",
                projected_columns=["projectedColumns"],
                source=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                )
            ),
            rename_columns_step=quicksight.CfnDataSet.RenameColumnsOperationProperty(
                alias="alias",
                rename_column_operations=[quicksight.CfnDataSet.RenameColumnOperationProperty(
                    column_name="columnName",
                    new_column_name="newColumnName"
                )],
                source=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                )
            ),
            unpivot_step=quicksight.CfnDataSet.UnpivotOperationProperty(
                alias="alias",
                columns_to_unpivot=[quicksight.CfnDataSet.ColumnToUnpivotProperty(
                    column_name="columnName",
                    new_value="newValue"
                )],
                source=quicksight.CfnDataSet.TransformOperationSourceProperty(
                    transform_operation_id="transformOperationId",

                    # the properties below are optional
                    column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
                        source_column_id="sourceColumnId",
                        target_column_id="targetColumnId"
                    )]
                ),
                unpivoted_label_column_id="unpivotedLabelColumnId",
                unpivoted_label_column_name="unpivotedLabelColumnName",
                unpivoted_value_column_id="unpivotedValueColumnId",
                unpivoted_value_column_name="unpivotedValueColumnName"
            )
        )
    }
)
java
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import software.amazon.awscdk.services.quicksight.*;

DataPrepConfigurationProperty dataPrepConfigurationProperty = DataPrepConfigurationProperty.builder()
        .destinationTableMap(Map.of(
                "destinationTableMapKey", DestinationTableProperty.builder()
                        .alias("alias")
                        .source(DestinationTableSourceProperty.builder()
                                .transformOperationId("transformOperationId")
                                .build())
                        .build()))
        .sourceTableMap(Map.of(
                "sourceTableMapKey", SourceTableProperty.builder()
                        .dataSet(ParentDataSetProperty.builder()
                                .dataSetArn("dataSetArn")
                                .inputColumns(List.of(InputColumnProperty.builder()
                                        .name("name")
                                        .type("type")

                                        // the properties below are optional
                                        .id("id")
                                        .subType("subType")
                                        .build()))
                                .build())
                        .physicalTableId("physicalTableId")
                        .build()))
        .transformStepMap(Map.of(
                "transformStepMapKey", TransformStepProperty.builder()
                        .aggregateStep(AggregateOperationProperty.builder()
                                .aggregations(List.of(AggregationProperty.builder()
                                        .aggregationFunction(DataPrepAggregationFunctionProperty.builder()
                                                .listAggregation(DataPrepListAggregationFunctionProperty.builder()
                                                        .distinct(false)
                                                        .separator("separator")

                                                        // the properties below are optional
                                                        .inputColumnName("inputColumnName")
                                                        .build())
                                                .percentileAggregation(DataPrepPercentileAggregationFunctionProperty.builder()
                                                        .percentileValue(123)

                                                        // the properties below are optional
                                                        .inputColumnName("inputColumnName")
                                                        .build())
                                                .simpleAggregation(DataPrepSimpleAggregationFunctionProperty.builder()
                                                        .functionType("functionType")

                                                        // the properties below are optional
                                                        .inputColumnName("inputColumnName")
                                                        .build())
                                                .build())
                                        .newColumnId("newColumnId")
                                        .newColumnName("newColumnName")
                                        .build()))
                                .alias("alias")
                                .source(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())

                                // the properties below are optional
                                .groupByColumnNames(List.of("groupByColumnNames"))
                                .build())
                        .appendStep(AppendOperationProperty.builder()
                                .alias("alias")
                                .appendedColumns(List.of(AppendedColumnProperty.builder()
                                        .columnName("columnName")
                                        .newColumnId("newColumnId")
                                        .build()))

                                // the properties below are optional
                                .firstSource(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .secondSource(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .build())
                        .castColumnTypesStep(CastColumnTypesOperationProperty.builder()
                                .alias("alias")
                                .castColumnTypeOperations(List.of(CastColumnTypeOperationProperty.builder()
                                        .columnName("columnName")
                                        .newColumnType("newColumnType")

                                        // the properties below are optional
                                        .format("format")
                                        .subType("subType")
                                        .build()))
                                .source(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .build())
                        .createColumnsStep(CreateColumnsOperationProperty.builder()
                                .columns(List.of(CalculatedColumnProperty.builder()
                                        .columnId("columnId")
                                        .columnName("columnName")
                                        .expression("expression")
                                        .build()))

                                // the properties below are optional
                                .alias("alias")
                                .source(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .build())
                        .filtersStep(FiltersOperationProperty.builder()
                                .alias("alias")
                                .filterOperations(List.of(FilterOperationProperty.builder()
                                        .conditionExpression("conditionExpression")
                                        .dateFilterCondition(DataSetDateFilterConditionProperty.builder()
                                                .columnName("columnName")
                                                .comparisonFilterCondition(DataSetDateComparisonFilterConditionProperty.builder()
                                                        .operator("operator")

                                                        // the properties below are optional
                                                        .value(DataSetDateFilterValueProperty.builder()
                                                                .staticValue("staticValue")
                                                                .build())
                                                        .build())
                                                .rangeFilterCondition(DataSetDateRangeFilterConditionProperty.builder()
                                                        .includeMaximum(false)
                                                        .includeMinimum(false)
                                                        .rangeMaximum(DataSetDateFilterValueProperty.builder()
                                                                .staticValue("staticValue")
                                                                .build())
                                                        .rangeMinimum(DataSetDateFilterValueProperty.builder()
                                                                .staticValue("staticValue")
                                                                .build())
                                                        .build())
                                                .build())
                                        .numericFilterCondition(DataSetNumericFilterConditionProperty.builder()
                                                .columnName("columnName")
                                                .comparisonFilterCondition(DataSetNumericComparisonFilterConditionProperty.builder()
                                                        .operator("operator")

                                                        // the properties below are optional
                                                        .value(DataSetNumericFilterValueProperty.builder()
                                                                .staticValue(123)
                                                                .build())
                                                        .build())
                                                .rangeFilterCondition(DataSetNumericRangeFilterConditionProperty.builder()
                                                        .includeMaximum(false)
                                                        .includeMinimum(false)
                                                        .rangeMaximum(DataSetNumericFilterValueProperty.builder()
                                                                .staticValue(123)
                                                                .build())
                                                        .rangeMinimum(DataSetNumericFilterValueProperty.builder()
                                                                .staticValue(123)
                                                                .build())
                                                        .build())
                                                .build())
                                        .stringFilterCondition(DataSetStringFilterConditionProperty.builder()
                                                .columnName("columnName")
                                                .comparisonFilterCondition(DataSetStringComparisonFilterConditionProperty.builder()
                                                        .operator("operator")

                                                        // the properties below are optional
                                                        .value(DataSetStringFilterValueProperty.builder()
                                                                .staticValue("staticValue")
                                                                .build())
                                                        .build())
                                                .listFilterCondition(DataSetStringListFilterConditionProperty.builder()
                                                        .operator("operator")

                                                        // the properties below are optional
                                                        .values(DataSetStringListFilterValueProperty.builder()
                                                                .staticValues(List.of("staticValues"))
                                                                .build())
                                                        .build())
                                                .build())
                                        .build()))
                                .source(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .build())
                        .importTableStep(ImportTableOperationProperty.builder()
                                .alias("alias")
                                .source(ImportTableOperationSourceProperty.builder()
                                        .sourceTableId("sourceTableId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .build())
                        .joinStep(JoinOperationProperty.builder()
                                .alias("alias")
                                .leftOperand(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .onClause("onClause")
                                .rightOperand(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .type("type")

                                // the properties below are optional
                                .leftOperandProperties(JoinOperandPropertiesProperty.builder()
                                        .outputColumnNameOverrides(List.of(OutputColumnNameOverrideProperty.builder()
                                                .outputColumnName("outputColumnName")

                                                // the properties below are optional
                                                .sourceColumnName("sourceColumnName")
                                                .build()))
                                        .build())
                                .rightOperandProperties(JoinOperandPropertiesProperty.builder()
                                        .outputColumnNameOverrides(List.of(OutputColumnNameOverrideProperty.builder()
                                                .outputColumnName("outputColumnName")

                                                // the properties below are optional
                                                .sourceColumnName("sourceColumnName")
                                                .build()))
                                        .build())
                                .build())
                        .pivotStep(PivotOperationProperty.builder()
                                .alias("alias")
                                .pivotConfiguration(PivotConfigurationProperty.builder()
                                        .pivotedLabels(List.of(PivotedLabelProperty.builder()
                                                .labelName("labelName")
                                                .newColumnId("newColumnId")
                                                .newColumnName("newColumnName")
                                                .build()))

                                        // the properties below are optional
                                        .labelColumnName("labelColumnName")
                                        .build())
                                .source(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .valueColumnConfiguration(ValueColumnConfigurationProperty.builder()
                                        .aggregationFunction(DataPrepAggregationFunctionProperty.builder()
                                                .listAggregation(DataPrepListAggregationFunctionProperty.builder()
                                                        .distinct(false)
                                                        .separator("separator")

                                                        // the properties below are optional
                                                        .inputColumnName("inputColumnName")
                                                        .build())
                                                .percentileAggregation(DataPrepPercentileAggregationFunctionProperty.builder()
                                                        .percentileValue(123)

                                                        // the properties below are optional
                                                        .inputColumnName("inputColumnName")
                                                        .build())
                                                .simpleAggregation(DataPrepSimpleAggregationFunctionProperty.builder()
                                                        .functionType("functionType")

                                                        // the properties below are optional
                                                        .inputColumnName("inputColumnName")
                                                        .build())
                                                .build())
                                        .build())

                                // the properties below are optional
                                .groupByColumnNames(List.of("groupByColumnNames"))
                                .build())
                        .projectStep(ProjectOperationProperty.builder()
                                .alias("alias")
                                .projectedColumns(List.of("projectedColumns"))
                                .source(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .build())
                        .renameColumnsStep(RenameColumnsOperationProperty.builder()
                                .alias("alias")
                                .renameColumnOperations(List.of(RenameColumnOperationProperty.builder()
                                        .columnName("columnName")
                                        .newColumnName("newColumnName")
                                        .build()))
                                .source(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .build())
                        .unpivotStep(UnpivotOperationProperty.builder()
                                .alias("alias")
                                .columnsToUnpivot(List.of(ColumnToUnpivotProperty.builder()
                                        .columnName("columnName")
                                        .newValue("newValue")
                                        .build()))
                                .source(TransformOperationSourceProperty.builder()
                                        .transformOperationId("transformOperationId")

                                        // the properties below are optional
                                        .columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
                                                .sourceColumnId("sourceColumnId")
                                                .targetColumnId("targetColumnId")
                                                .build()))
                                        .build())
                                .unpivotedLabelColumnId("unpivotedLabelColumnId")
                                .unpivotedLabelColumnName("unpivotedLabelColumnName")
                                .unpivotedValueColumnId("unpivotedValueColumnId")
                                .unpivotedValueColumnName("unpivotedValueColumnName")
                                .build())
                        .build()))
        .build();
csharp
// Install: dotnet add package Amazon.CDK.Lib
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
using Amazon.CDK.AWS.QuickSight;

var dataPrepConfigurationProperty = new DataPrepConfigurationProperty {
    DestinationTableMap = new Dictionary<string, object> {
        { "destinationTableMapKey", new DestinationTableProperty {
            Alias = "alias",
            Source = new DestinationTableSourceProperty {
                TransformOperationId = "transformOperationId"
            }
        } }
    },
    SourceTableMap = new Dictionary<string, object> {
        { "sourceTableMapKey", new SourceTableProperty {
            DataSet = new ParentDataSetProperty {
                DataSetArn = "dataSetArn",
                InputColumns = new [] { new InputColumnProperty {
                    Name = "name",
                    Type = "type",

                    // the properties below are optional
                    Id = "id",
                    SubType = "subType"
                } }
            },
            PhysicalTableId = "physicalTableId"
        } }
    },
    TransformStepMap = new Dictionary<string, object> {
        { "transformStepMapKey", new TransformStepProperty {
            AggregateStep = new AggregateOperationProperty {
                Aggregations = new [] { new AggregationProperty {
                    AggregationFunction = new DataPrepAggregationFunctionProperty {
                        ListAggregation = new DataPrepListAggregationFunctionProperty {
                            Distinct = false,
                            Separator = "separator",

                            // the properties below are optional
                            InputColumnName = "inputColumnName"
                        },
                        PercentileAggregation = new DataPrepPercentileAggregationFunctionProperty {
                            PercentileValue = 123,

                            // the properties below are optional
                            InputColumnName = "inputColumnName"
                        },
                        SimpleAggregation = new DataPrepSimpleAggregationFunctionProperty {
                            FunctionType = "functionType",

                            // the properties below are optional
                            InputColumnName = "inputColumnName"
                        }
                    },
                    NewColumnId = "newColumnId",
                    NewColumnName = "newColumnName"
                } },
                Alias = "alias",
                Source = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                },

                // the properties below are optional
                GroupByColumnNames = new [] { "groupByColumnNames" }
            },
            AppendStep = new AppendOperationProperty {
                Alias = "alias",
                AppendedColumns = new [] { new AppendedColumnProperty {
                    ColumnName = "columnName",
                    NewColumnId = "newColumnId"
                } },

                // the properties below are optional
                FirstSource = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                },
                SecondSource = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                }
            },
            CastColumnTypesStep = new CastColumnTypesOperationProperty {
                Alias = "alias",
                CastColumnTypeOperations = new [] { new CastColumnTypeOperationProperty {
                    ColumnName = "columnName",
                    NewColumnType = "newColumnType",

                    // the properties below are optional
                    Format = "format",
                    SubType = "subType"
                } },
                Source = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                }
            },
            CreateColumnsStep = new CreateColumnsOperationProperty {
                Columns = new [] { new CalculatedColumnProperty {
                    ColumnId = "columnId",
                    ColumnName = "columnName",
                    Expression = "expression"
                } },

                // the properties below are optional
                Alias = "alias",
                Source = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                }
            },
            FiltersStep = new FiltersOperationProperty {
                Alias = "alias",
                FilterOperations = new [] { new FilterOperationProperty {
                    ConditionExpression = "conditionExpression",
                    DateFilterCondition = new DataSetDateFilterConditionProperty {
                        ColumnName = "columnName",
                        ComparisonFilterCondition = new DataSetDateComparisonFilterConditionProperty {
                            Operator = "operator",

                            // the properties below are optional
                            Value = new DataSetDateFilterValueProperty {
                                StaticValue = "staticValue"
                            }
                        },
                        RangeFilterCondition = new DataSetDateRangeFilterConditionProperty {
                            IncludeMaximum = false,
                            IncludeMinimum = false,
                            RangeMaximum = new DataSetDateFilterValueProperty {
                                StaticValue = "staticValue"
                            },
                            RangeMinimum = new DataSetDateFilterValueProperty {
                                StaticValue = "staticValue"
                            }
                        }
                    },
                    NumericFilterCondition = new DataSetNumericFilterConditionProperty {
                        ColumnName = "columnName",
                        ComparisonFilterCondition = new DataSetNumericComparisonFilterConditionProperty {
                            Operator = "operator",

                            // the properties below are optional
                            Value = new DataSetNumericFilterValueProperty {
                                StaticValue = 123
                            }
                        },
                        RangeFilterCondition = new DataSetNumericRangeFilterConditionProperty {
                            IncludeMaximum = false,
                            IncludeMinimum = false,
                            RangeMaximum = new DataSetNumericFilterValueProperty {
                                StaticValue = 123
                            },
                            RangeMinimum = new DataSetNumericFilterValueProperty {
                                StaticValue = 123
                            }
                        }
                    },
                    StringFilterCondition = new DataSetStringFilterConditionProperty {
                        ColumnName = "columnName",
                        ComparisonFilterCondition = new DataSetStringComparisonFilterConditionProperty {
                            Operator = "operator",

                            // the properties below are optional
                            Value = new DataSetStringFilterValueProperty {
                                StaticValue = "staticValue"
                            }
                        },
                        ListFilterCondition = new DataSetStringListFilterConditionProperty {
                            Operator = "operator",

                            // the properties below are optional
                            Values = new DataSetStringListFilterValueProperty {
                                StaticValues = new [] { "staticValues" }
                            }
                        }
                    }
                } },
                Source = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                }
            },
            ImportTableStep = new ImportTableOperationProperty {
                Alias = "alias",
                Source = new ImportTableOperationSourceProperty {
                    SourceTableId = "sourceTableId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                }
            },
            JoinStep = new JoinOperationProperty {
                Alias = "alias",
                LeftOperand = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                },
                OnClause = "onClause",
                RightOperand = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                },
                Type = "type",

                // the properties below are optional
                LeftOperandProperties = new JoinOperandPropertiesProperty {
                    OutputColumnNameOverrides = new [] { new OutputColumnNameOverrideProperty {
                        OutputColumnName = "outputColumnName",

                        // the properties below are optional
                        SourceColumnName = "sourceColumnName"
                    } }
                },
                RightOperandProperties = new JoinOperandPropertiesProperty {
                    OutputColumnNameOverrides = new [] { new OutputColumnNameOverrideProperty {
                        OutputColumnName = "outputColumnName",

                        // the properties below are optional
                        SourceColumnName = "sourceColumnName"
                    } }
                }
            },
            PivotStep = new PivotOperationProperty {
                Alias = "alias",
                PivotConfiguration = new PivotConfigurationProperty {
                    PivotedLabels = new [] { new PivotedLabelProperty {
                        LabelName = "labelName",
                        NewColumnId = "newColumnId",
                        NewColumnName = "newColumnName"
                    } },

                    // the properties below are optional
                    LabelColumnName = "labelColumnName"
                },
                Source = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                },
                ValueColumnConfiguration = new ValueColumnConfigurationProperty {
                    AggregationFunction = new DataPrepAggregationFunctionProperty {
                        ListAggregation = new DataPrepListAggregationFunctionProperty {
                            Distinct = false,
                            Separator = "separator",

                            // the properties below are optional
                            InputColumnName = "inputColumnName"
                        },
                        PercentileAggregation = new DataPrepPercentileAggregationFunctionProperty {
                            PercentileValue = 123,

                            // the properties below are optional
                            InputColumnName = "inputColumnName"
                        },
                        SimpleAggregation = new DataPrepSimpleAggregationFunctionProperty {
                            FunctionType = "functionType",

                            // the properties below are optional
                            InputColumnName = "inputColumnName"
                        }
                    }
                },

                // the properties below are optional
                GroupByColumnNames = new [] { "groupByColumnNames" }
            },
            ProjectStep = new ProjectOperationProperty {
                Alias = "alias",
                ProjectedColumns = new [] { "projectedColumns" },
                Source = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                }
            },
            RenameColumnsStep = new RenameColumnsOperationProperty {
                Alias = "alias",
                RenameColumnOperations = new [] { new RenameColumnOperationProperty {
                    ColumnName = "columnName",
                    NewColumnName = "newColumnName"
                } },
                Source = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                }
            },
            UnpivotStep = new UnpivotOperationProperty {
                Alias = "alias",
                ColumnsToUnpivot = new [] { new ColumnToUnpivotProperty {
                    ColumnName = "columnName",
                    NewValue = "newValue"
                } },
                Source = new TransformOperationSourceProperty {
                    TransformOperationId = "transformOperationId",

                    // the properties below are optional
                    ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                        SourceColumnId = "sourceColumnId",
                        TargetColumnId = "targetColumnId"
                    } }
                },
                UnpivotedLabelColumnId = "unpivotedLabelColumnId",
                UnpivotedLabelColumnName = "unpivotedLabelColumnName",
                UnpivotedValueColumnId = "unpivotedValueColumnId",
                UnpivotedValueColumnName = "unpivotedValueColumnName"
            }
        } }
    }
};
go
// Install: go get github.com/aws/aws-cdk-go/awscdk/v2
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import "github.com/aws/aws-cdk-go/awscdk"

dataPrepConfigurationProperty := &DataPrepConfigurationProperty{
	DestinationTableMap: map[string]interface{}{
		"destinationTableMapKey": &DestinationTableProperty{
			"alias": jsii.String("alias"),
			"source": &DestinationTableSourceProperty{
				"transformOperationId": jsii.String("transformOperationId"),
			},
		},
	},
	SourceTableMap: map[string]interface{}{
		"sourceTableMapKey": &SourceTableProperty{
			"dataSet": &ParentDataSetProperty{
				"dataSetArn": jsii.String("dataSetArn"),
				"inputColumns": []interface{}{
					&InputColumnProperty{
						"name": jsii.String("name"),
						"type": jsii.String("type"),

						// the properties below are optional
						"id": jsii.String("id"),
						"subType": jsii.String("subType"),
					},
				},
			},
			"physicalTableId": jsii.String("physicalTableId"),
		},
	},
	TransformStepMap: map[string]interface{}{
		"transformStepMapKey": &TransformStepProperty{
			"aggregateStep": &AggregateOperationProperty{
				"aggregations": []interface{}{
					&AggregationProperty{
						"aggregationFunction": &DataPrepAggregationFunctionProperty{
							"listAggregation": &DataPrepListAggregationFunctionProperty{
								"distinct": jsii.Boolean(false),
								"separator": jsii.String("separator"),

								// the properties below are optional
								"inputColumnName": jsii.String("inputColumnName"),
							},
							"percentileAggregation": &DataPrepPercentileAggregationFunctionProperty{
								"percentileValue": jsii.Number(123),

								// the properties below are optional
								"inputColumnName": jsii.String("inputColumnName"),
							},
							"simpleAggregation": &DataPrepSimpleAggregationFunctionProperty{
								"functionType": jsii.String("functionType"),

								// the properties below are optional
								"inputColumnName": jsii.String("inputColumnName"),
							},
						},
						"newColumnId": jsii.String("newColumnId"),
						"newColumnName": jsii.String("newColumnName"),
					},
				},
				"alias": jsii.String("alias"),
				"source": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},

				// the properties below are optional
				"groupByColumnNames": []*string{
					jsii.String("groupByColumnNames"),
				},
			},
			"appendStep": &AppendOperationProperty{
				"alias": jsii.String("alias"),
				"appendedColumns": []interface{}{
					&AppendedColumnProperty{
						"columnName": jsii.String("columnName"),
						"newColumnId": jsii.String("newColumnId"),
					},
				},

				// the properties below are optional
				"firstSource": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
				"secondSource": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
			},
			"castColumnTypesStep": &CastColumnTypesOperationProperty{
				"alias": jsii.String("alias"),
				"castColumnTypeOperations": []interface{}{
					&CastColumnTypeOperationProperty{
						"columnName": jsii.String("columnName"),
						"newColumnType": jsii.String("newColumnType"),

						// the properties below are optional
						"format": jsii.String("format"),
						"subType": jsii.String("subType"),
					},
				},
				"source": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
			},
			"createColumnsStep": &CreateColumnsOperationProperty{
				"columns": []interface{}{
					&CalculatedColumnProperty{
						"columnId": jsii.String("columnId"),
						"columnName": jsii.String("columnName"),
						"expression": jsii.String("expression"),
					},
				},

				// the properties below are optional
				"alias": jsii.String("alias"),
				"source": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
			},
			"filtersStep": &FiltersOperationProperty{
				"alias": jsii.String("alias"),
				"filterOperations": []interface{}{
					&FilterOperationProperty{
						"conditionExpression": jsii.String("conditionExpression"),
						"dateFilterCondition": &DataSetDateFilterConditionProperty{
							"columnName": jsii.String("columnName"),
							"comparisonFilterCondition": &DataSetDateComparisonFilterConditionProperty{
								"operator": jsii.String("operator"),

								// the properties below are optional
								"value": &DataSetDateFilterValueProperty{
									"staticValue": jsii.String("staticValue"),
								},
							},
							"rangeFilterCondition": &DataSetDateRangeFilterConditionProperty{
								"includeMaximum": jsii.Boolean(false),
								"includeMinimum": jsii.Boolean(false),
								"rangeMaximum": &DataSetDateFilterValueProperty{
									"staticValue": jsii.String("staticValue"),
								},
								"rangeMinimum": &DataSetDateFilterValueProperty{
									"staticValue": jsii.String("staticValue"),
								},
							},
						},
						"numericFilterCondition": &DataSetNumericFilterConditionProperty{
							"columnName": jsii.String("columnName"),
							"comparisonFilterCondition": &DataSetNumericComparisonFilterConditionProperty{
								"operator": jsii.String("operator"),

								// the properties below are optional
								"value": &DataSetNumericFilterValueProperty{
									"staticValue": jsii.Number(123),
								},
							},
							"rangeFilterCondition": &DataSetNumericRangeFilterConditionProperty{
								"includeMaximum": jsii.Boolean(false),
								"includeMinimum": jsii.Boolean(false),
								"rangeMaximum": &DataSetNumericFilterValueProperty{
									"staticValue": jsii.Number(123),
								},
								"rangeMinimum": &DataSetNumericFilterValueProperty{
									"staticValue": jsii.Number(123),
								},
							},
						},
						"stringFilterCondition": &DataSetStringFilterConditionProperty{
							"columnName": jsii.String("columnName"),
							"comparisonFilterCondition": &DataSetStringComparisonFilterConditionProperty{
								"operator": jsii.String("operator"),

								// the properties below are optional
								"value": &DataSetStringFilterValueProperty{
									"staticValue": jsii.String("staticValue"),
								},
							},
							"listFilterCondition": &DataSetStringListFilterConditionProperty{
								"operator": jsii.String("operator"),

								// the properties below are optional
								"values": &DataSetStringListFilterValueProperty{
									"staticValues": []*string{
										jsii.String("staticValues"),
									},
								},
							},
						},
					},
				},
				"source": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
			},
			"importTableStep": &ImportTableOperationProperty{
				"alias": jsii.String("alias"),
				"source": &ImportTableOperationSourceProperty{
					"sourceTableId": jsii.String("sourceTableId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
			},
			"joinStep": &JoinOperationProperty{
				"alias": jsii.String("alias"),
				"leftOperand": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
				"onClause": jsii.String("onClause"),
				"rightOperand": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
				"type": jsii.String("type"),

				// the properties below are optional
				"leftOperandProperties": &JoinOperandPropertiesProperty{
					"outputColumnNameOverrides": []interface{}{
						&OutputColumnNameOverrideProperty{
							"outputColumnName": jsii.String("outputColumnName"),

							// the properties below are optional
							"sourceColumnName": jsii.String("sourceColumnName"),
						},
					},
				},
				"rightOperandProperties": &JoinOperandPropertiesProperty{
					"outputColumnNameOverrides": []interface{}{
						&OutputColumnNameOverrideProperty{
							"outputColumnName": jsii.String("outputColumnName"),

							// the properties below are optional
							"sourceColumnName": jsii.String("sourceColumnName"),
						},
					},
				},
			},
			"pivotStep": &PivotOperationProperty{
				"alias": jsii.String("alias"),
				"pivotConfiguration": &PivotConfigurationProperty{
					"pivotedLabels": []interface{}{
						&PivotedLabelProperty{
							"labelName": jsii.String("labelName"),
							"newColumnId": jsii.String("newColumnId"),
							"newColumnName": jsii.String("newColumnName"),
						},
					},

					// the properties below are optional
					"labelColumnName": jsii.String("labelColumnName"),
				},
				"source": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
				"valueColumnConfiguration": &ValueColumnConfigurationProperty{
					"aggregationFunction": &DataPrepAggregationFunctionProperty{
						"listAggregation": &DataPrepListAggregationFunctionProperty{
							"distinct": jsii.Boolean(false),
							"separator": jsii.String("separator"),

							// the properties below are optional
							"inputColumnName": jsii.String("inputColumnName"),
						},
						"percentileAggregation": &DataPrepPercentileAggregationFunctionProperty{
							"percentileValue": jsii.Number(123),

							// the properties below are optional
							"inputColumnName": jsii.String("inputColumnName"),
						},
						"simpleAggregation": &DataPrepSimpleAggregationFunctionProperty{
							"functionType": jsii.String("functionType"),

							// the properties below are optional
							"inputColumnName": jsii.String("inputColumnName"),
						},
					},
				},

				// the properties below are optional
				"groupByColumnNames": []*string{
					jsii.String("groupByColumnNames"),
				},
			},
			"projectStep": &ProjectOperationProperty{
				"alias": jsii.String("alias"),
				"projectedColumns": []*string{
					jsii.String("projectedColumns"),
				},
				"source": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
			},
			"renameColumnsStep": &RenameColumnsOperationProperty{
				"alias": jsii.String("alias"),
				"renameColumnOperations": []interface{}{
					&RenameColumnOperationProperty{
						"columnName": jsii.String("columnName"),
						"newColumnName": jsii.String("newColumnName"),
					},
				},
				"source": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
			},
			"unpivotStep": &UnpivotOperationProperty{
				"alias": jsii.String("alias"),
				"columnsToUnpivot": []interface{}{
					&ColumnToUnpivotProperty{
						"columnName": jsii.String("columnName"),
						"newValue": jsii.String("newValue"),
					},
				},
				"source": &TransformOperationSourceProperty{
					"transformOperationId": jsii.String("transformOperationId"),

					// the properties below are optional
					"columnIdMappings": []interface{}{
						&DataSetColumnIdMappingProperty{
							"sourceColumnId": jsii.String("sourceColumnId"),
							"targetColumnId": jsii.String("targetColumnId"),
						},
					},
				},
				"unpivotedLabelColumnId": jsii.String("unpivotedLabelColumnId"),
				"unpivotedLabelColumnName": jsii.String("unpivotedLabelColumnName"),
				"unpivotedValueColumnId": jsii.String("unpivotedValueColumnId"),
				"unpivotedValueColumnName": jsii.String("unpivotedValueColumnName"),
			},
		},
	},
}

Properties ​

destinationTableMapIResolvable | { [key: string]: IResolvable | CfnDataSet.DestinationTableProperty }destination_table_maptyping.Union[IResolvable, typing.Mapping[str, typing.Union[IResolvable, DestinationTableProperty]]]destinationTableMapIResolvableDestinationTableMapIResolvableDestinationTableMapinterface{}required#
A map of destination tables that receive the final prepared data.
sourceTableMapIResolvable | { [key: string]: IResolvable | CfnDataSet.SourceTableProperty }source_table_maptyping.Union[IResolvable, typing.Mapping[str, typing.Union[IResolvable, SourceTableProperty]]]sourceTableMapIResolvableSourceTableMapIResolvableSourceTableMapinterface{}required#
A map of source tables that provide information about underlying sources.
transformStepMapIResolvable | { [key: string]: IResolvable | CfnDataSet.TransformStepProperty }transform_step_maptyping.Union[IResolvable, typing.Mapping[str, typing.Union[IResolvable, TransformStepProperty]]]transformStepMapIResolvableTransformStepMapIResolvableTransformStepMapinterface{}required#
A map of transformation steps that process the data.