Skip to content

Introduction to the Satisfies Expression Check

The Satisfies Expression check evaluates a Spark SQL expression against every record and reports the ones where it does not hold. It is the escape hatch of the rule catalog: when the logic you need spans several fields, branches on a condition, or has no dedicated rule, you write it yourself.

This section is the complete guide to the check. The Deep Dive covers the definition, properties, and full evaluation semantics, explains how anomalies are reported, walks through production examples, and collects best practices; the How-tos are step-by-step tutorials for creating, editing, and deleting a check; the API page documents the payload for programmatic use; and the FAQ answers the most frequent questions.

Next Steps

  • How It Works

    The complete reference: definition, field scope, what the expression must return, check variables, NULL handling, filter behavior, and coverage.

    How It Works

  • Anomaly Reporting

    The anomaly messages the check produces, what the numbers mean, Source Records behavior, and Custom Anomaly Description.

    Anomaly Reporting

  • Examples

    Three production scenarios with sample data, anomaly messages, and the SQL equivalent of what the check evaluates.

    Examples

  • Best Practices

    Guidelines for writing expressions that stay readable, handling NULLs deliberately, and knowing when a dedicated rule is better.

    Best Practices

  • Permissions

    The team permission each action needs: view, create, edit, archive, restore, and delete.

    Permissions

  • Create a Check

    Step-by-step tutorial for creating a Satisfies Expression check with a custom SQL condition.

    Create a Check

  • Edit a Check

    Step-by-step tutorial for changing the expression, the filter, or the coverage on an existing check.

    Edit a Check

  • Delete a Check

    Step-by-step tutorial for archiving a check and deleting it permanently.

    Delete a Check

  • Troubleshooting

    Common problems with NULL results, invalid expressions, performance, and anomaly reporting.

    Troubleshooting

  • API

    Payload shape and field notes for creating a Satisfies Expression check programmatically.

    API

  • FAQ

    Short answers to questions about the expression, NULL handling, check variables, and anomaly reporting.

    FAQ