AnalysisRuleAggregation
import type { AnalysisRuleAggregation } from "https://aws-api.deno.dev/v0.4/services/cleanrooms.ts?docs=full";Enables query structure and specified queries that product aggregate statistics.
interface AnalysisRuleAggregation {
aggregateColumns: AggregateColumn[];
dimensionColumns: string[];
joinColumns: string[];
joinRequired?: JoinRequiredOption | null;
outputConstraints: AggregationConstraint[];
scalarFunctions: ScalarFunctions[];
}§Properties
§
aggregateColumns: AggregateColumn[]
[src]The columns that query runners are allowed to use in aggregation queries.
§
dimensionColumns: string[]
[src]The columns that query runners are allowed to select, group by, or filter by.
§
joinColumns: string[]
[src]Columns in configured table that can be used in join statements and/or as aggregate columns. They can never be outputted directly.
§
joinRequired?: JoinRequiredOption | null
[src]Control that requires member who runs query to do a join with their configured table and/or other configured table in query
§
outputConstraints: AggregationConstraint[]
[src]Columns that must meet a specific threshold value (after an aggregation function is applied to it) for each output row to be returned.
§
scalarFunctions: ScalarFunctions[]
[src]Set of scalar functions that are allowed to be used on dimension columns and the output of aggregation of metrics.