Data Cloud Data Model Objects
This skill activates when a practitioner needs to design or manage Data Model Objects (DMOs) in Salesforce Data Cloud. DMOs are the semantic layer of the Customer 360 Data Model — they are logical groupings of data stored in Data Lake Objects (DLOs) and organized into subject areas. This skill covers DMO schema design, mandatory DMOs for identity resolution, the XMD (extended metadata) layer for field formatting, and the data transform types that can create or populate DMOs.
Before Starting
Gather this context before working on anything in this domain:
- DMOs do NOT support SOQL. Queries against DMO data require the Data Cloud Query API (ANSI SQL), not standard Salesforce SOQL. Attempting to query a DMO via SOQL will fail.
- Five DMOs are mandatory for identity resolution: Individual, Party Identification, Contact Point Email, Contact Point Phone, and Contact Point Address. Data streams that do not map to these DMOs cannot participate in identity resolution.
- Only one data relationship is permitted per field pair between two mapped DMOs. Multiple relationships between the same two fields are not supported.
- XMD (extended metadata) has three tiers: System XMD (platform-generated, immutable), Main XMD (org-customizable via REST API), and User XMD (per-user preferences). You can only modify Main XMD, not System XMD.
- Streaming transforms are restricted to a single DLO (no cross-DLO joins); batch transforms support joins and aggregations across multiple DLOs.
Core Concepts
DMO Architecture: DLO → DMO Layer
Data Cloud stores raw ingested data in Data Lake Objects (DLOs). DMOs are a semantic abstraction layer on top of DLOs:
- DLO — Raw storage: one DLO per data stream source. Fields are ingested as-is.
- DMO — Semantic model: curated schema with business-friendly names, relationships, and subject area classification. Multiple DLOs can map to a single DMO.
- Subject Areas — Organizational groups within the Customer 360 Data Model (e.g., Sales Order, Unified Individual, Marketing). DMOs belong to a subject area.
Field mapping from DLO to DMO is configured in the Data Stream setup. This mapping determines which DLO fields populate which DMO fields.
Five Mandatory DMOs for Identity Resolution
Identity resolution in Data Cloud requires data to be mapped to specific standard DMOs:
| DMO |
Purpose |
Individual |
Unified customer/person record |
Party Identification |
External IDs linking a person to source systems |
Contact Point Email |
Email addresses linked to Individual |
Contact Point Phone |
Phone numbers linked to Individual |
Contact Point Address |
Physical addresses linked to Individual |
Data streams that omit field mappings to these DMOs cannot contribute to unified identity profiles. The identity resolution ruleset operates exclusively on these five DMOs.
XMD: Extended Metadata Layer
XMD controls how Data Cloud fields are displayed: labels, formatting, data type hints, and measure/dimension classification. It has three immutable tiers:
- System XMD — Automatically generated by the platform when a dataset or DMO is created. Cannot be modified.
- Main XMD — Org-level customization. Can be updated via
PATCH /services/data/v{version}/wave/datasets/{datasetId}/xmds/main. This is the correct layer for adding field labels, aliases, and formatting properties.
- User XMD — Per-user preferences applied on top of Main XMD. Cannot be updated via API; managed by end users in the interface.
Attempting to update System XMD fields via the REST API returns an error. Identify the XMD type before attempting to modify it.
Streaming vs. Batch Transforms
Two transform types create or populate DMO records from DLO data:
Streaming Transforms:
- Execute near-real-time on new DLO records as they arrive
- Support only a single source DLO per transform (no joins)
- Cannot perform aggregations
- Use for event enrichment that does not require cross-source joins
Batch Transforms:
- Execute on a scheduled interval
- Support joins across multiple DLOs and aggregations
- Use for analytical metrics, cross-source unified views, or enrichment requiring multiple data sources
Common Patterns
Pattern 1: Custom DMO Schema Design
When to use: Onboarding a new data source that doesn't map to any existing standard DMO — e.g., a custom loyalty transaction object.
How it works:
- Define the DMO name, API name, and subject area assignment
- Identify the source DLO(s) and define field mappings (source field → DMO field)
- Determine if the DMO needs a relationship to another DMO (e.g., linking loyalty transactions to the Individual DMO)
- Create only one data relationship per field pair — multiple relationships between the same two DMO fields are not allowed
- Map identity-relevant fields (email, phone, address) to the five mandatory DMOs in a separate data stream if they exist in the source
Why not use SOQL to query the DMO: DMOs are columnar stores, not Salesforce objects. SOQL does not work against DMO data. Use the Data Cloud Query API with ANSI SQL to query DMO records.
Pattern 2: Main XMD Update for Field Label Customization
When to use: Field labels in a Data Cloud dataset or DMO need to be renamed for business-friendly display without modifying the underlying field API name.
How it works:
- Retrieve the current Main XMD:
GET /services/data/v{version}/wave/datasets/{datasetId}/xmds/main
- Modify the
fields array in the XMD JSON: update label, alias, or formatting properties for the target field
- Submit the updated XMD:
PATCH /services/data/v{version}/wave/datasets/{datasetId}/xmds/main
- Validate the change by querying the dataset in CRM Analytics or Data Cloud interface
Why not edit System XMD: System XMD is platform-generated and immutable. PATCH requests targeting System XMD return a 403 error. Always work with Main XMD.
Decision Guidance
| Situation |
Recommended Approach |
Reason |
| New data source, identity-relevant fields |
Map to mandatory identity DMOs (Individual, Party ID, Contact Points) |
Required for identity resolution participation |
| Cross-source data join for analytics |
Batch Transform |
Streaming transforms support only single DLO; joins require batch |
| Near-real-time enrichment, single source |
Streaming Transform |
Faster execution; no join needed |
| Field label/format customization |
PATCH Main XMD via REST API |
Only Main XMD is modifiable; System XMD is immutable |
| Querying DMO data |
Data Cloud Query API (ANSI SQL) |
SOQL does not work against DMO objects |
| Relationship between two DMOs |
One relationship per field pair maximum |
Platform limit: multiple relationships on same field pair not supported |
Recommended Workflow
- Inventory source data schema — Document all entities, fields, data types, and relationships in the source system.
- Map to Customer 360 Data Model subject areas — Identify which standard DMOs the source data fits. Create custom DMOs only for entities with no standard DMO equivalent.
- Design mandatory DMO mappings for identity resolution — Confirm that identity-relevant fields (email, phone, address, external IDs) are mapped to the five mandatory DMOs.
- Define data relationships — Document which DMOs need relationships. Enforce the one-relationship-per-field-pair limit during design.
- Select transform type — For each DMO population path, choose streaming (single source, near-real-time) or batch (multi-source join, scheduled).
- Design XMD customization — Identify which fields need label changes or formatting updates. Plan Main XMD PATCH calls for each.
- Validate with Data Cloud Query API — After DMO population, run ANSI SQL queries via the Data Cloud Query API to confirm field values and relationship traversal.
Review Checklist
Salesforce-Specific Gotchas
- DMOs do not support SOQL — DMOs are columnar stores in the Data Cloud data lake, not Salesforce objects in the CRM object model. SOQL queries against DMO API names return errors or empty results. All DMO data access requires the Data Cloud Query API with ANSI SQL syntax.
- System XMD is immutable — PATCH against it returns 403 — System XMD is auto-generated by the platform and cannot be modified. Main XMD is the correct target for field customization. Always retrieve the XMD type before attempting to patch it.
- Only one data relationship per field pair between DMOs — You cannot create two separate data relationships between the same pair of fields on two DMOs. If a more complex mapping is needed, it must be modeled as a different field pairing or through a transform.
Output Artifacts
| Artifact |
Description |
| DMO schema design document |
Entity list with subject area, field definitions, and relationship map |
| Mandatory DMO mapping checklist |
Confirmation that all five identity-resolution DMOs are mapped |
| Transform type selection |
Streaming vs. batch decision for each DMO population path |
| XMD update specification |
Field labels, aliases, and formatting changes as PATCH payload |
Related Skills
data/data-cloud-data-streams — For configuring DLO ingestion and field mapping from source to DLO
admin/data-cloud-identity-resolution — For identity resolution ruleset design and matching rule configuration
admin/data-cloud-segmentation — For building segments that query unified DMO profiles
architect/data-cloud-architecture — For overall Data Cloud platform architecture and deployment planning
1---2name: data-cloud-data-model-objects3description: "Use when designing or managing Data Model Objects (DMOs) in Salesforce Data Cloud — covers DMO schema design, subject area governance, data relationships between DMOs, XMD (extended metadata) layer management, data transforms (streaming vs. batch), and mandatory DMO requirements for identity resolution. NOT for standard Salesforce CRM object design, Data Cloud data stream configuration, or SOQL queries against Data Cloud objects."4category: data5salesforce-version: "Spring '25+"6well-architected-pillars:7 - Operational Excellence8 - Reliability9triggers:10 - "How do I design custom Data Model Objects in Data Cloud for my data schema?"11 - "What DMOs are required for identity resolution to work in Data Cloud?"12 - "How to update XMD field labels and formatting in Data Cloud datasets"13 - "Data Cloud DMO relationship limit — only one relationship per field pair allowed"14 - "Difference between streaming transforms and batch transforms in Data Cloud DMOs"15tags:16 - data-cloud17 - DMO18 - XMD19 - data-model20 - identity-resolution21 - data-transforms22inputs:23 - "Source data schema: entities, fields, data types, and relationships"24 - "Identity resolution scope: which DMOs need to feed matching rules"25 - "Subject area taxonomy: how entities should be organized in the Customer 360 Data Model"26outputs:27 - "DMO schema design with subject area assignments and field definitions"28 - "Mandatory DMO checklist for identity resolution"29 - "Data transform type selection (streaming vs. batch) per use case"30 - "XMD update API specification for field formatting customization"31dependencies: []32version: 1.0.033author: Pranav Nagrecha34updated: 2026-04-1635metadata:36 source: https://skillmd.com/skills/banibratachatterjee/data-cloud-data-model-objects37---3839# Data Cloud Data Model Objects4041This skill activates when a practitioner needs to design or manage Data Model Objects (DMOs) in Salesforce Data Cloud. DMOs are the semantic layer of the Customer 360 Data Model — they are logical groupings of data stored in Data Lake Objects (DLOs) and organized into subject areas. This skill covers DMO schema design, mandatory DMOs for identity resolution, the XMD (extended metadata) layer for field formatting, and the data transform types that can create or populate DMOs.4243---4445## Before Starting4647Gather this context before working on anything in this domain:4849- DMOs do NOT support SOQL. Queries against DMO data require the Data Cloud Query API (ANSI SQL), not standard Salesforce SOQL. Attempting to query a DMO via SOQL will fail.50- Five DMOs are mandatory for identity resolution: Individual, Party Identification, Contact Point Email, Contact Point Phone, and Contact Point Address. Data streams that do not map to these DMOs cannot participate in identity resolution.51- Only one data relationship is permitted per field pair between two mapped DMOs. Multiple relationships between the same two fields are not supported.52- XMD (extended metadata) has three tiers: System XMD (platform-generated, immutable), Main XMD (org-customizable via REST API), and User XMD (per-user preferences). You can only modify Main XMD, not System XMD.53- Streaming transforms are restricted to a single DLO (no cross-DLO joins); batch transforms support joins and aggregations across multiple DLOs.5455---5657## Core Concepts5859### DMO Architecture: DLO → DMO Layer6061Data Cloud stores raw ingested data in Data Lake Objects (DLOs). DMOs are a semantic abstraction layer on top of DLOs:6263- **DLO** — Raw storage: one DLO per data stream source. Fields are ingested as-is.64- **DMO** — Semantic model: curated schema with business-friendly names, relationships, and subject area classification. Multiple DLOs can map to a single DMO.65- **Subject Areas** — Organizational groups within the Customer 360 Data Model (e.g., Sales Order, Unified Individual, Marketing). DMOs belong to a subject area.6667Field mapping from DLO to DMO is configured in the Data Stream setup. This mapping determines which DLO fields populate which DMO fields.6869### Five Mandatory DMOs for Identity Resolution7071Identity resolution in Data Cloud requires data to be mapped to specific standard DMOs:7273| DMO | Purpose |74|---|---|75| `Individual` | Unified customer/person record |76| `Party Identification` | External IDs linking a person to source systems |77| `Contact Point Email` | Email addresses linked to Individual |78| `Contact Point Phone` | Phone numbers linked to Individual |79| `Contact Point Address` | Physical addresses linked to Individual |8081Data streams that omit field mappings to these DMOs cannot contribute to unified identity profiles. The identity resolution ruleset operates exclusively on these five DMOs.8283### XMD: Extended Metadata Layer8485XMD controls how Data Cloud fields are displayed: labels, formatting, data type hints, and measure/dimension classification. It has three immutable tiers:8687- **System XMD** — Automatically generated by the platform when a dataset or DMO is created. Cannot be modified.88- **Main XMD** — Org-level customization. Can be updated via `PATCH /services/data/v{version}/wave/datasets/{datasetId}/xmds/main`. This is the correct layer for adding field labels, aliases, and formatting properties.89- **User XMD** — Per-user preferences applied on top of Main XMD. Cannot be updated via API; managed by end users in the interface.9091Attempting to update System XMD fields via the REST API returns an error. Identify the XMD type before attempting to modify it.9293### Streaming vs. Batch Transforms9495Two transform types create or populate DMO records from DLO data:9697**Streaming Transforms:**98- Execute near-real-time on new DLO records as they arrive99- Support only a single source DLO per transform (no joins)100- Cannot perform aggregations101- Use for event enrichment that does not require cross-source joins102103**Batch Transforms:**104- Execute on a scheduled interval105- Support joins across multiple DLOs and aggregations106- Use for analytical metrics, cross-source unified views, or enrichment requiring multiple data sources107108---109110## Common Patterns111112### Pattern 1: Custom DMO Schema Design113114**When to use:** Onboarding a new data source that doesn't map to any existing standard DMO — e.g., a custom loyalty transaction object.115116**How it works:**1171. Define the DMO name, API name, and subject area assignment1182. Identify the source DLO(s) and define field mappings (source field → DMO field)1193. Determine if the DMO needs a relationship to another DMO (e.g., linking loyalty transactions to the Individual DMO)1204. Create only one data relationship per field pair — multiple relationships between the same two DMO fields are not allowed1215. Map identity-relevant fields (email, phone, address) to the five mandatory DMOs in a separate data stream if they exist in the source122123**Why not use SOQL to query the DMO:** DMOs are columnar stores, not Salesforce objects. SOQL does not work against DMO data. Use the Data Cloud Query API with ANSI SQL to query DMO records.124125### Pattern 2: Main XMD Update for Field Label Customization126127**When to use:** Field labels in a Data Cloud dataset or DMO need to be renamed for business-friendly display without modifying the underlying field API name.128129**How it works:**1301. Retrieve the current Main XMD: `GET /services/data/v{version}/wave/datasets/{datasetId}/xmds/main`1312. Modify the `fields` array in the XMD JSON: update `label`, `alias`, or formatting properties for the target field1323. Submit the updated XMD: `PATCH /services/data/v{version}/wave/datasets/{datasetId}/xmds/main`1334. Validate the change by querying the dataset in CRM Analytics or Data Cloud interface134135**Why not edit System XMD:** System XMD is platform-generated and immutable. PATCH requests targeting System XMD return a 403 error. Always work with Main XMD.136137---138139## Decision Guidance140141| Situation | Recommended Approach | Reason |142|---|---|---|143| New data source, identity-relevant fields | Map to mandatory identity DMOs (Individual, Party ID, Contact Points) | Required for identity resolution participation |144| Cross-source data join for analytics | Batch Transform | Streaming transforms support only single DLO; joins require batch |145| Near-real-time enrichment, single source | Streaming Transform | Faster execution; no join needed |146| Field label/format customization | PATCH Main XMD via REST API | Only Main XMD is modifiable; System XMD is immutable |147| Querying DMO data | Data Cloud Query API (ANSI SQL) | SOQL does not work against DMO objects |148| Relationship between two DMOs | One relationship per field pair maximum | Platform limit: multiple relationships on same field pair not supported |149150---151152## Recommended Workflow1531541. **Inventory source data schema** — Document all entities, fields, data types, and relationships in the source system.1552. **Map to Customer 360 Data Model subject areas** — Identify which standard DMOs the source data fits. Create custom DMOs only for entities with no standard DMO equivalent.1563. **Design mandatory DMO mappings for identity resolution** — Confirm that identity-relevant fields (email, phone, address, external IDs) are mapped to the five mandatory DMOs.1574. **Define data relationships** — Document which DMOs need relationships. Enforce the one-relationship-per-field-pair limit during design.1585. **Select transform type** — For each DMO population path, choose streaming (single source, near-real-time) or batch (multi-source join, scheduled).1596. **Design XMD customization** — Identify which fields need label changes or formatting updates. Plan Main XMD PATCH calls for each.1607. **Validate with Data Cloud Query API** — After DMO population, run ANSI SQL queries via the Data Cloud Query API to confirm field values and relationship traversal.161162---163164## Review Checklist165166- [ ] Five mandatory DMOs mapped for identity resolution (Individual, Party ID, Email, Phone, Address)167- [ ] Data relationships limited to one per field pair between DMO pairs168- [ ] XMD updates target Main XMD, not System XMD169- [ ] Streaming transforms restricted to single-DLO sources; joins use batch transforms170- [ ] DMO queries use Data Cloud Query API (ANSI SQL), not SOQL171- [ ] Subject area assignments documented for each custom DMO172173---174175## Salesforce-Specific Gotchas1761771. **DMOs do not support SOQL** — DMOs are columnar stores in the Data Cloud data lake, not Salesforce objects in the CRM object model. SOQL queries against DMO API names return errors or empty results. All DMO data access requires the Data Cloud Query API with ANSI SQL syntax.1782. **System XMD is immutable — PATCH against it returns 403** — System XMD is auto-generated by the platform and cannot be modified. Main XMD is the correct target for field customization. Always retrieve the XMD type before attempting to patch it.1793. **Only one data relationship per field pair between DMOs** — You cannot create two separate data relationships between the same pair of fields on two DMOs. If a more complex mapping is needed, it must be modeled as a different field pairing or through a transform.180181---182183## Output Artifacts184185| Artifact | Description |186|---|---|187| DMO schema design document | Entity list with subject area, field definitions, and relationship map |188| Mandatory DMO mapping checklist | Confirmation that all five identity-resolution DMOs are mapped |189| Transform type selection | Streaming vs. batch decision for each DMO population path |190| XMD update specification | Field labels, aliases, and formatting changes as PATCH payload |191192---193194## Related Skills195196- `data/data-cloud-data-streams` — For configuring DLO ingestion and field mapping from source to DLO197- `admin/data-cloud-identity-resolution` — For identity resolution ruleset design and matching rule configuration198- `admin/data-cloud-segmentation` — For building segments that query unified DMO profiles199- `architect/data-cloud-architecture` — For overall Data Cloud platform architecture and deployment planning