Map
Apply semantic labels to your data columns to create a common language across all your source systems. The Map module transforms disparate column names into standardized semantic terms that enable accurate matching and unified reporting.Why Semantic Mapping Matters
Every system has its own naming conventions. One system calls it “PatientFirstName,” another calls it “first_nm,” and a third uses “fname.” Without a common vocabulary, these systems can’t communicate effectively. Semantic mapping solves this by:- Creating a unified vocabulary across all data sources
- Enabling accurate matching by aligning equivalent fields
- Supporting consistent reporting and analytics
- Preserving the relationship between source and canonical data
What You Can Do
Assign Semantic Labels
Map source columns to standardized labels like FirstName, LastName, DateOfBirth, SSN.
Set Primary Keys
Designate which column uniquely identifies records in each source table.
Map from a Searchable Picker
Search your entities and columns, then pick a label from a dropdown — no hand-typed column names.
Create Your Own Labels
Add labels your organization needs, each with its own description and encryption setting, from the Labels page.
Manage the Label Catalog
Search the catalog, edit a label in place, and remove several labels at once with multi-select bulk delete.
Run and Watch the Stage
Confirm the run, follow live status in the run window, and reopen the history of previous mapping runs.
Semantic Label Categories
Identity
FirstName, LastName, MiddleName, Suffix, DateOfBirth, SSN, MRN
Contact
Email, Phone, MobilePhone, Address, City, State, ZipCode
Demographics
Gender, Race, Ethnicity, Language, MaritalStatus
Clinical
DiagnosisCode, ProcedureCode, ProviderNPI, FacilityID
Financial
InsuranceID, MemberID, GroupNumber, PayerName
Custom Labels
Organization-specific labels for unique data elements
Key Capabilities
Intelligent Suggestions
skyMDM analyzes column names and sample data to suggest likely semantic labels. Columns named “dob” or “birth_date” are automatically suggested for DateOfBirth.Sensitivity and Encryption Classification
Each label carries an encryption setting that marks how the underlying attribute should be handled. The Labels page summarizes the result across your data — how many sensitive attributes exist, how many are mapped, and how many are encrypted — giving privacy and compliance teams a single view of where protected data sits.Mapping Validation
A label can only be assigned once per table. If the same label is applied to two columns, skyMDM names the conflict and blocks the save rather than letting an ambiguous mapping reach Match. Primary keys are chosen from a dropdown of eligible key columns only, and a stale primary key can always be cleared.Cross-Source Alignment
View how labels are mapped across all your source tables to ensure consistency and identify gaps in your semantic model.Runs Where Your Data Lives
Mapping executes natively on Databricks, Snowflake, or Microsoft Fabric, running per table and writing the mapped output back into your own catalog or lakehouse.Business Impact
Accurate Matching
Semantic alignment ensures matching algorithms compare the right fields.
Unified Reporting
Consistent labels enable cross-source analytics and reporting.
Faster Onboarding
New data sources are integrated faster with standardized mapping.
Who Benefits
- Data Architects: Design and maintain the enterprise semantic model
- Data Engineers: Quickly map new data sources to existing standards
- Analytics Teams: Query across sources using consistent field names
- Integration Teams: Reduce mapping errors when connecting systems