Skip to main content

Validate

Ensure your data meets quality standards before it flows into downstream systems. The Validate module applies intelligent validation rules to detect invalid emails, malformed phone numbers, incorrect dates, and other data quality issues.

Why Validation Matters​

Clean data isn't necessarily valid data. A phone number might be properly formatted but contain an invalid area code. An email might look correct but use an impossible domain. A date might be formatted correctly but represent an impossible value.

Validation catches these issues before they cause problems:

  • Invalid contact information leads to failed patient outreach
  • Incorrect dates create scheduling conflicts and compliance issues
  • Bad data propagates through systems, compounding errors

skyMDM's Validate module provides comprehensive data validation at scale.

What You Can Do​

Auto-Detect Validation Types

skyMDM automatically suggests validation types based on column names and data patterns.

Validate Multiple Types

Apply email, phone, date, ZIP code, and custom validations to your columns.

View Quality Scores

See the percentage of valid records for each column and validation type.

Track Trends

Monitor how validation scores change over time as data quality improves.

Build Your Own Validators

Describe the rule you need in plain language and skyMDM drafts the check for you, ready to review, name, and save.

Manage the Validator Catalog

Review every custom validator your tenant has created, edit or delete them, and see which columns still depend on one.

Validation Types​

Email Validation

Verify email format, domain validity, and deliverability indicators

Phone Validation

Check phone number format, valid area codes, and number type (mobile, landline)

Date Validation

Validate date formats, reasonable ranges, and logical consistency

ZIP and State Validation

Check ZIP codes against the US ZIP database and normalize state abbreviations

Name and Gender Validation

Confirm person-name and gender values fall within expected forms

Custom Validators

Tenant-defined checks for organization-specific rules, generated from a plain-language description

Key Capabilities​

Intelligent Column Detection​

skyMDM analyzes column names and sample data to automatically suggest appropriate validation types. Columns named "email" or "phone" are detected and pre-configured.

Validation Statistics​

After validation runs, detailed statistics show exactly how your data performed—valid counts, invalid counts, null counts, and percentage breakdowns.

Column Profiling Integration​

Validation builds on the column metadata from cleaning, providing a complete picture of data quality from basic statistics to semantic validation.

Custom Validator Lifecycle​

Write a custom validator once and it appears in the validation-type list for every column in the tenant. Each validator keeps its own name and description, and its generated logic is checked before it is saved. A validator that is still in use cannot be deleted by accident — skyMDM refuses the delete and tells you exactly which columns still reference it.

Preflight Connectivity Check​

Before a validation run starts, skyMDM probes the connection to your warehouse. If it cannot reach the data, you get one clear, actionable error instead of a separate failure for every rule in the run.

Honest Run Results​

Rules that could not be evaluated are reported as skipped rather than counted as passing, so a quality score always reflects checks that actually ran. Runs that stall are self-healed, and the run window keeps the full history of previous validations for the table with the person who triggered each one.

Scalable Execution​

Validation runs natively on Databricks, Snowflake, or Microsoft Fabric, handling millions of records with efficient parallel processing. skyMDM blocks a run on a table that has no rules configured yet, rather than submitting an empty job.

Business Impact​

Improve Outreach

Validated contact information increases successful patient communications.

Reduce Errors

Catch data issues before they impact clinical or operational workflows.

Build Confidence

Stakeholders trust data backed by validation metrics and quality scores.

Who Benefits​

  • Patient Access Teams: Ensure contact information is valid for appointment reminders and outreach
  • Marketing Teams: Improve campaign effectiveness with validated email and phone data
  • Quality Assurance: Track and report on data quality metrics across the organization
  • Data Engineers: Identify data quality issues at the source for upstream fixes