Unify Event Data Across Schemas and View Merged Data in the UI

Hi Experience League Community,

I have a case where fragments of event data are stored in two databases, and I am seeking a way to unify this data into a single event. I tested creating a relationship field and was able to reference the schema fields in segmentation.

I would like to know:

1. Is this the only implication of implementing a schema relationship?
2. Is there a way to visibly see the merged event data in the UI? For example, can we view a single event containing all fields from both the source schema and the reference schema?

Here are my schemas:

Schema #1 (Event Class):

• _id
• timestamp
• eventType
• reservationId
• transactionId (relationship field)
• amount

Schema #2 (Custom Class):

• transactionId (primary ID)
• memberId
• orderType
• outletId

I would appreciate it if anyone could share their thoughts on this.

Regards,
Zac