Interface CfnDataSet.TransformStepProperty
- All Superinterfaces:
software.amazon.jsii.JsiiSerializable
- All Known Implementing Classes:
CfnDataSet.TransformStepProperty.Jsii$Proxy
- Enclosing class:
CfnDataSet
Example:
// 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.*;
TransformStepProperty transformStepProperty = 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();
- See Also:
-
Nested Class Summary
Nested ClassesModifier and TypeInterfaceDescriptionstatic final classA builder forCfnDataSet.TransformStepPropertystatic final classAn implementation forCfnDataSet.TransformStepProperty -
Method Summary
Modifier and TypeMethodDescriptionbuilder()default ObjectA transform step that groups data and applies aggregation functions to calculate summary values.default ObjectA transform step that combines rows from multiple sources by stacking them vertically.default ObjectA transform step that changes the data types of one or more columns.default ObjectA transform operation that creates calculated columns.default ObjectA transform step that applies filter conditions.default ObjectA transform step that brings data from a source table.default ObjectA transform step that combines data from two sources based on specified join conditions.default ObjectA transform step that converts row values into columns to reshape the data structure.default ObjectA transform operation that projects columns.default ObjectA transform step that changes the names of one or more columns.default ObjectA transform step that converts columns into rows to normalize the data structure.Methods inherited from interface software.amazon.jsii.JsiiSerializable
$jsii$toJson
-
Method Details
-
getAggregateStep
A transform step that groups data and applies aggregation functions to calculate summary values.Returns union: either
IResolvableorCfnDataSet.AggregateOperationProperty- See Also:
-
getAppendStep
A transform step that combines rows from multiple sources by stacking them vertically.Returns union: either
IResolvableorCfnDataSet.AppendOperationProperty- See Also:
-
getCastColumnTypesStep
A transform step that changes the data types of one or more columns.Returns union: either
IResolvableorCfnDataSet.CastColumnTypesOperationProperty- See Also:
-
getCreateColumnsStep
A transform operation that creates calculated columns.
Columns created in one such operation form a lexical closure.
Returns union: either
IResolvableorCfnDataSet.CreateColumnsOperationProperty- See Also:
-
getFiltersStep
A transform step that applies filter conditions.Returns union: either
IResolvableorCfnDataSet.FiltersOperationProperty- See Also:
-
getImportTableStep
A transform step that brings data from a source table.Returns union: either
IResolvableorCfnDataSet.ImportTableOperationProperty- See Also:
-
getJoinStep
A transform step that combines data from two sources based on specified join conditions.Returns union: either
IResolvableorCfnDataSet.JoinOperationProperty- See Also:
-
getPivotStep
A transform step that converts row values into columns to reshape the data structure.Returns union: either
IResolvableorCfnDataSet.PivotOperationProperty- See Also:
-
getProjectStep
A transform operation that projects columns.
Operations that come after a projection can only refer to projected columns.
Returns union: either
IResolvableorCfnDataSet.ProjectOperationProperty- See Also:
-
getRenameColumnsStep
A transform step that changes the names of one or more columns.Returns union: either
IResolvableorCfnDataSet.RenameColumnsOperationProperty- See Also:
-
getUnpivotStep
A transform step that converts columns into rows to normalize the data structure.Returns union: either
IResolvableorCfnDataSet.UnpivotOperationProperty- See Also:
-
builder
-