Merges dataset for the legacy data schema
Learn about the merges dataset for the column-based schema.
This table holds data for all entity merges. Use these datasets to view your entity merge metadata.
| Field | Description | Data type/Mode |
|---|---|---|
| mergeKey | The loser identifier of the entity. For more information, see topic Merge SnapLogic data in Reltio. | Data type: STRING Mode: NULLABLE |
| deleted | An indicator that tells you whether the entity is deleted or not. | Data type: BOOLEAN Mode: NULLABLE |
| winnerId | The entity ID of the winner entity. | Data type: STRING Mode: NULLABLE |
| loserId | The entity ID of the loser entity. | Data type: STRING Mode: NULLABLE |
| matchRules | All the match rules used to merge the entities. | Data type: STRING Mode: REPEATED |
| version | The object version in Reltio. | Data type: INTEGER Mode: NULLABLE |
| timestamp | The timestamp of the event in Reltio. | Data type: INTEGER Mode: NULLABLE |
| insertedTime | The time when the merge was inserted in the GBQ table. | Data type: TIMESTAMP Mode: NULLABLE |
| type | The type of event that occurred. It could be:
| Data type: STRING Mode: NULLABLE |
| mergeRulesUris | The URI of the merge rules. The configuration/entityTypes/Organization/matchGroups/FuzzyNameExactAddress URI corresponds to the match rule defined in your L3 under the Organization entity type. | Data type: STRING Mode: REPEATED |