AggregationPolicy

Snowflake Documentation

Represents an aggregation policy in Snowflake, which defines constraints on aggregation operations.

Examples

Python

aggregation_policy = AggregationPolicy(
    name="some_aggregation_policy",
    body="AGGREGATION_CONSTRAINT(MIN_GROUP_SIZE => 5)",
    owner="SYSADMIN"
)

YAML

aggregation_policies:
  - name: some_aggregation_policy
    body: AGGREGATION_CONSTRAINT(MIN_GROUP_SIZE => 5)
    owner: SYSADMIN

Fields

• name (string, required) - The name of the aggregation policy.

• body (string, required) - The SQL expression defining the aggregation constraint.

• owner (string or Role) - The owner of the aggregation policy. Defaults to "SYSADMIN".