AWS::CleanRooms::ConfiguredTable AggregationConstraint
Constraint on query output removing output rows that do not meet a minimum number of distinct values of a specified column.
Syntax
To declare this entity in your Amazon CloudFormation template, use the following syntax:
JSON
{ "ColumnName" :
String
, "Minimum" :Number
, "Type" :String
}
YAML
ColumnName:
String
Minimum:Number
Type:String
Properties
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.
Required: Yes
Type: String
Pattern:
^[a-z0-9_](([a-z0-9_ ]+-)*([a-z0-9_ ]+))?$
Minimum:
1
Maximum:
127
Update requires: No interruption
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.
Required: Yes
Type: Number
Minimum:
2
Maximum:
100000
Update requires: No interruption
Type
-
The type of aggregation the constraint allows. The only valid value is currently `COUNT_DISTINCT`.
Required: Yes
Type: String
Allowed values:
COUNT_DISTINCT
Update requires: No interruption