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 AWS 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