Root Key is the primary key of the primary data model object (DMO) of the data graph. In a data graph, a root key is the main identifier. It is also the initial access point for data retrieval. This is the primary key of the primary DMO.
Required Editions
| Available in: All Editions supported by Data 360. See Data 360 edition availability. |
| User Permission Set Needed | |
|---|---|
| To add or remove root key indicators in DMO metadata: |
Permission set:
|
Adding a metadata indicator for objects with a root key simplifies the computation process by identifying and using the root key in incoming data. This eliminates unnecessary lookups during refresh runs.
If the metadata indicator is unavailable, the refresh process defaults to the traditional computation method. For example, in a data graph structure, the primary DMO is Customer DMO, with Website Engagement and Case Details as child DMOs.The Website Engagement Data Model Object (DMO) contains the customer ID which happens to be the root key. You can tag this customer ID as the root key. The Website Engagement DMO uses the metadata directly, specifically the embedded root key to streamline the data graph computation. However, the Case Details DMO still relies on the legacy computation process for querying.
When creating or editing a data graph, you can indicate a field as a root key. To manage the root key indicator in the DMO's metadata, follow these steps:
- Navigate to the object that isn’t directly related to the primary DMO and select the field.
- Click Select as Root Key. To later remove the metadata indicator, select the field and click Remove as Root Key.