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).