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
columnName	`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.