Basic Filters¶
Use the following examples to apply basic filtering and focus checks on specific data subsets:
-- Validate completeness only for active customers
-- Filter:
customer_status = 'ACTIVE'
-- Check uniqueness within specific date ranges
duplicate_count(transaction_id) = 0
-- Filter:
transaction_date >= '2024-01-01'
You can also combine multiple filters using logical operators (AND/OR):
-- Check data quality for recent, high-value transactions
duplicate_count(order_id) = 0
-- Filters:
transaction_date >= '2024-01-01' AND order_amount > 1000
-- Validate email completeness for active users in specific regions
missing_count(email) = 0
-- Filters:
status = 'ACTIVE' AND (region = 'US' OR region = 'EU')
Note
Alation Data Quality currently doesn’t support grouping filters under parenthesis.
For example, (order_type = 'PHYSICAL' AND shipping_method != 'PICKUP')
or (customer_tier = 'PREMIUM' AND order_amount > 500)
.