Class CfnConfiguredTable.AggregationConstraintProperty
Constraint on query output removing output rows that do not meet a minimum number of distinct values of a specified column.
Implements
Inherited Members
Namespace: Amazon.CDK.AwsCleanrooms
Assembly: Amazon.CDK.Lib.dll
Syntax (csharp)
public class CfnConfiguredTable.AggregationConstraintProperty : CfnConfiguredTable.IAggregationConstraintProperty
Syntax (vb)
Public Class CfnConfiguredTable.AggregationConstraintProperty Implements CfnConfiguredTable.IAggregationConstraintProperty
Remarks
ExampleMetadata: fixture=_generated
Examples
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
using Amazon.CDK.Aws_cleanrooms;
var aggregationConstraintProperty = new AggregationConstraintProperty {
ColumnName = "columnName",
Minimum = 123,
Type = "type"
};
Synopsis
Constructors
AggregationConstraintProperty() | Constraint on query output removing output rows that do not meet a minimum number of distinct values of a specified column. |
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. |
Minimum | The minimum number of distinct values that an output row must be an aggregation of. |
Type | The type of aggregation the constraint allows. |
Constructors
AggregationConstraintProperty()
Constraint on query output removing output rows that do not meet a minimum number of distinct values of a specified column.
public AggregationConstraintProperty()
Remarks
ExampleMetadata: fixture=_generated
Examples
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
using Amazon.CDK.Aws_cleanrooms;
var aggregationConstraintProperty = new AggregationConstraintProperty {
ColumnName = "columnName",
Minimum = 123,
Type = "type"
};
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.
public string ColumnName { get; set; }
Property Value
Remarks
Minimum
The minimum number of distinct values that an output row must be an aggregation of.
public double Minimum { get; set; }
Property Value
Remarks
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
The type of aggregation the constraint allows.
public string Type { get; set; }
Property Value
Remarks
The only valid value is currently COUNT_DISTINCT
.