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.