Data quality rules

Write the rule in SQL, or let the platform build it. Reconciliations, proportions and trends are all first-class test types.

  • SQL-based business rule validations, unit tests, regression tests, and ad-hoc checks
  • Data reconciliation for comparing multiple datasets with drag-and-drop column mapping and auto-generated SQL
  • Percentage-based test cases for proportion-driven quality rules
  • Trend-based thresholds that judge a result against its own history using prediction models, instead of a fixed limit
List of data quality tests in SelectZero

Automated test generation

Most checks should not need a developer. Pick a standard validation, describe a rule in plain words, or accept a suggestion.

  • Standard validations: simple checks for completeness, uniqueness, allowed values, regex, date ranges, data freshness, and more
  • Natural language to SQL: describe a data quality rule to generate a test case automatically
  • Validation suggestions based on metadata and profiling history
  • Reusable SQL templates with custom parameters for bulk test creation
  • Business rules linked to glossary terms, generating a test case for every attribute that carries the term
Creating standard validations in SelectZero

Monitoring & alerting

Run validations at every pipeline stage and see exactly which rows failed, were fixed, or keep coming back.

  • Scheduled by interval or CRON, individually or in test suites, or triggered via API at any pipeline stage
  • Alerts by email or webhook (Slack, Teams, Jira, and more) on failures or on changes to the test itself, with the breached rows included
  • Row-level execution diffs showing newly introduced, resolved, and recurring failures across runs
  • Full change history for every test case, results kept per execution, and an as-of view of any past run
Row-level differences between two test runs

Dashboards & reporting

Give each team the view it needs, and give stakeholders a dashboard they can open without asking.

  • Role-based dashboards combining test suites, reports, business rules, test cases and data objects in one view
  • Flexible grid layouts with chart, entity-detail, execution, schedule and alert tiles, tailored to each team or domain
  • Drilldown from any score to the test cases and profiling rules behind it
  • Custom reports filtered by custom fields, for metrics per quality dimension (availability, uniqueness, accuracy) or domain
  • Test suite reports as HTML or Excel, sent by email and kept for past executions
A data quality dashboard in SelectZero

See it on your own data.

SelectZero runs inside your own environment, with your access rules in place and no data leaving it. Try the sandbox, or book a demo.

Loading calendar…