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