interface AggregationConstraintProperty
| Language | Type name |
|---|---|
 .NET | Amazon.CDK.aws_cleanrooms.CfnConfiguredTable.AggregationConstraintProperty |
 Go | github.com/aws/aws-cdk-go/awscdk/v2/awscleanrooms#CfnConfiguredTable_AggregationConstraintProperty |
 Java | software.amazon.awscdk.services.cleanrooms.CfnConfiguredTable.AggregationConstraintProperty |
 Python | aws_cdk.aws_cleanrooms.CfnConfiguredTable.AggregationConstraintProperty |
 TypeScript | aws-cdk-lib » aws_cleanrooms » CfnConfiguredTable » AggregationConstraintProperty |
Constraint on query output removing output rows that do not meet a minimum number of distinct values of a specified column.
Example
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { aws_cleanrooms as cleanrooms } from 'aws-cdk-lib';
const aggregationConstraintProperty: cleanrooms.CfnConfiguredTable.AggregationConstraintProperty = {
columnName: 'columnName',
minimum: 123,
type: 'type',
};
Properties
| Name | Type | Description |
|---|---|---|
| column | string | 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. |
| minimum | number | The minimum number of distinct values that an output row must be an aggregation of. |
| type | string | The type of aggregation the constraint allows. |
columnName
Type:
string
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.
minimum
Type:
number
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
Type:
string
The type of aggregation the constraint allows.
The only valid value is currently COUNT_DISTINCT.