AWS::CleanRooms::ConfiguredTable AggregationConstraint - Amazon CloudFormation
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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