AggregationConstraint
Constraint on query output removing output rows that do not meet a minimum number of distinct values of a specified column.
Contents
- columnName
-
Column in aggregation constraint for which there must be a minimum number of distinct values in an output row for it to be in the query output.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 127.
Pattern:
[a-z0-9_](([a-z0-9_ ]+-)*([a-z0-9_ ]+))?Required: Yes
- minimum
-
The minimum number of distinct values that an output row must be an aggregation of. Minimum threshold of distinct values for a specified column that must exist in an output row for it to be in the query output.
Type: Integer
Valid Range: Minimum value of 2. Maximum value of 100000.
Required: Yes
- type
-
The type of aggregation the constraint allows. The only valid value is currently `COUNT_DISTINCT`.
Type: String
Valid Values:
COUNT_DISTINCTRequired: Yes
See Also
For more information about using this API in one of the language-specific AWS SDKs, see the following:
