interface AggregationConstraintProperty

Language	Type name
.NET	`Amazon.CDK.Mixins.Preview.AWS.CleanRooms.Mixins.CfnConfiguredTablePropsMixin.AggregationConstraintProperty`
Go	`github.com/aws/aws-cdk-go/awscdkmixinspreview/v2/awscleanrooms/mixins#CfnConfiguredTablePropsMixin_AggregationConstraintProperty`
Java	`software.amazon.awscdk.mixins.preview.services.cleanrooms.mixins.CfnConfiguredTablePropsMixin.AggregationConstraintProperty`
Python	`aws_cdk.mixins_preview.aws_cleanrooms.mixins.CfnConfiguredTablePropsMixin.AggregationConstraintProperty`
TypeScript	`@aws-cdk/mixins-preview` » `aws_cleanrooms` » `mixins` » `CfnConfiguredTablePropsMixin` » `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 { mixins as cleanrooms_mixins } from '@aws-cdk/mixins-preview/aws-cleanrooms';
const aggregationConstraintProperty: cleanrooms_mixins.CfnConfiguredTablePropsMixin.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 (optional)

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 (optional)

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 (optional)

The type of aggregation the constraint allows.

The only valid value is currently COUNT_DISTINCT.

AWS CDK