Leverage schema relationships

Adobe Experience Platform allows you to define relationships between schemas in order to use one dataset as a lookup table for another.

Let’s say your brand data model has a schema capturing purchases. You also have a schema for the product catalog. You can capture the product ID in the purchase schema and use a relationship to look up more complete product details from the product catalog. This allows you to create a segment for all customers who bought a laptop, for example, without having to explicitly list out all laptop IDs or capture every single product details in transactional systems.

To define a relationship, you need to have a dedicated field in the source schema, in this case the product ID field in the purchase schema. This field needs to reference the product ID field in the destination schema. The source and destination tables must be enabled for profiles and the destination schema must have that common field defined as its primary identity.

Here is the product catalog schema enabled for profile with the product ID defined as the primary identity.

Here is the purchase schema with the relationship defined on the product ID field.

NOTE
Learn more on schema relationships in the Experience Platform documentation.

In Journey Orchestration, you can then leverage all the fields from the linked tables:

  • when configuring a unitary event, Read more
  • when using conditions in a journey, Read more
  • in custom action personalization, Read more