Accelerate the Value of Data

Merges dataset for Snowflake

Learn about the merges dataset.

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: VARCHAR

Mode: NULLABLE

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

Mode: NULLABLE

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

Mode: NULLABLE

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

Mode: REPEATED

timestampThe timestamp of the event in Reltio.Data type: NUMBER(13,0)

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: VARCHAR

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: VARIANT

Mode: REPEATED

activeA value that indicates whether the merge is currently active or not.Data type: BOOLEAN

Mode: NULLABLE