interface AggregationConstraintProperty

Language	Type name
.NET	`Amazon.CDK.CfnPropertyMixins.AWS.CleanRooms.CfnConfiguredTablePropsMixin.AggregationConstraintProperty`
Go	`github.com/aws/aws-cdk-go/awscdkcfnpropertymixins/v2/awscleanrooms#CfnConfiguredTablePropsMixin_AggregationConstraintProperty`
Java	`software.amazon.awscdk.cfnpropertymixins.services.cleanrooms.CfnConfiguredTablePropsMixin.AggregationConstraintProperty`
Python	`aws_cdk.cfn_property_mixins.aws_cleanrooms.CfnConfiguredTablePropsMixin.AggregationConstraintProperty`
TypeScript	`@aws-cdk/cfn-property-mixins` » `aws_cleanrooms` » `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 { aws_cleanrooms as cleanrooms } from '@aws-cdk/cfn-property-mixins';
const aggregationConstraintProperty: cleanrooms.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