NULL and NOT NULL Filters

Use the following examples to apply NULL and NOT NULL filtering:

-- Validate data only where certain fields are populated

    invalid_count(phone_number) = 0

-- Filter:

    customer_tier IS NOT NULL

-- Check consistency in records with missing optional fields

    missing_count(secondary_email) <= 10

-- Filter:

    primary_email IS NULL