Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

TopicColumn - Amazon QuickSight

TopicColumn

Represents a column in a dataset.

Contents

Note

In the following list, the required parameters are described first.

ColumnName

The name of the column.

Type: String

Length Constraints: Maximum length of 256.

Required: Yes

Aggregation

The type of aggregation that is performed on the column data when it's queried.

Type: String

Valid Values: SUM | MAX | MIN | COUNT | DISTINCT_COUNT | AVERAGE | MEDIAN | STDEV | STDEVP | VAR | VARP

Required: No

AllowedAggregations

The list of aggregation types that are allowed for the column. Valid values for this structure are COUNT, DISTINCT_COUNT, MIN, MAX, MEDIAN, SUM, AVERAGE, STDEV, STDEVP, VAR, VARP, and PERCENTILE.

Type: Array of strings

Valid Values: COUNT | DISTINCT_COUNT | MIN | MAX | MEDIAN | SUM | AVERAGE | STDEV | STDEVP | VAR | VARP | PERCENTILE

Required: No

CellValueSynonyms

The other names or aliases for the column cell value.

Type: Array of CellValueSynonym objects

Required: No

ColumnDataRole

The role of the column in the data. Valid values are DIMENSION and MEASURE.

Type: String

Valid Values: DIMENSION | MEASURE

Required: No

ColumnDescription

A description of the column and its contents.

Type: String

Length Constraints: Maximum length of 256.

Required: No

ColumnFriendlyName

A user-friendly name for the column.

Type: String

Length Constraints: Maximum length of 256.

Required: No

ColumnSynonyms

The other names or aliases for the column.

Type: Array of strings

Length Constraints: Maximum length of 256.

Required: No

ComparativeOrder

The order in which data is displayed for the column when it's used in a comparative context.

Type: ComparativeOrder object

Required: No

DefaultFormatting

The default formatting used for values in the column.

Type: DefaultFormatting object

Required: No

DisableIndexing

A Boolean value that indicates whether the column shows in the autocomplete functionality.

Type: Boolean

Required: No

IsIncludedInTopic

A Boolean value that indicates whether the column is included in the query results.

Type: Boolean

Required: No

NeverAggregateInFilter

A Boolean value that indicates whether to aggregate the column data when it's used in a filter context.

Type: Boolean

Required: No

NonAdditive

The non additive value for the column.

Type: Boolean

Required: No

NotAllowedAggregations

The list of aggregation types that are not allowed for the column. Valid values for this structure are COUNT, DISTINCT_COUNT, MIN, MAX, MEDIAN, SUM, AVERAGE, STDEV, STDEVP, VAR, VARP, and PERCENTILE.

Type: Array of strings

Valid Values: COUNT | DISTINCT_COUNT | MIN | MAX | MEDIAN | SUM | AVERAGE | STDEV | STDEVP | VAR | VARP | PERCENTILE

Required: No

SemanticType

The semantic type of data contained in the column.

Type: SemanticType object

Required: No

TimeGranularity

The level of time precision that is used to aggregate DateTime values.

Type: String

Valid Values: SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | QUARTER | YEAR

Required: No

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following:

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.