- UNION or JOIN functions
- WHERE filters with literal (static) values
- first-party insights
- aggregation functions such as SUM or AVG
- JOIN functions
- first-party insights
- third-party insights
- WHERE filters
The correct answer is: WHERE filters with literal (static) values OR WHERE filters
Explanation: Columns in the HIGH and VERY_HIGH aggregation threshold categories cannot be used when applying WHERE filters to your query. This restriction exists to protect user privacy, as described in Amazon Marketing Cloud’s aggregation threshold documentation. For example, trying to filter directly on columns like postal_code (high) or user_id (very_high) using a WHERE clause is not allowed and the query will be rejected.
Reference content: From the official Amazon documentation (Data aggregation thresholds in AMC)
“Values from the column can only be included in the output of workflows if the row contains at least one hundred distinct users. The aggregation threshold is 100 and there are filtering restrictions. Filters using literal (static) values cannot be applied to the column. … For example, postal_code falls into this category and this filter is not allowed: WHERE postal_code in (10001, 10011).”
“Values from the column [very high category] … There are also filter restrictions. Filters using literal (static) values cannot be applied to the column. … For example, user_id falls into this category and this filter is not allowed: WHERE user_id in (111, 222).”