Accelerate the Value of Data

Merges dataset for the JSON data schema

Learn about the merges dataset for the JSON-based schema.

This table holds data for all entity merges. Use these datasets to view your entity merge metadata.
FieldDescriptionData type/Mode
mergeKeyThe loser identifier of the entity. For more information, see topic Merge SnapLogic data in Reltio. Data type: STRING

Mode: NULLABLE

deletedAn indicator that tells you whether the entity is deleted or not.Data type: BOOLEAN

Mode: NULLABLE

winnerIdThe entity ID of the winner entity.Data type: STRING

Mode: NULLABLE

loserIdThe entity ID of the loser entity.Data type: STRING

Mode: NULLABLE

matchRulesAll the match rules used to merge the entities.Data type: STRING

Mode: REPEATED

versionThe object version in Reltio.Data type: INTEGER

Mode: NULLABLE

timestampThe timestamp of the event in Reltio.Data type: INTEGER

Mode: NULLABLE

insertedTimeThe time when the merge was inserted in the GBQ table.Data type: TIMESTAMP

Mode: NULLABLE

typeThe type of event that occurred. It could be:
  • MANUAL: Two entities are manually merged.

  • AUTO: Two entities are automatically merged.

  • ON_THE_FLY: A newly created entity is merged with an existing entity using automatic match rules.

Data type: STRING

Mode: NULLABLE

mergeRulesUrisThe 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