Matches dataset for Snowflake
Learn about the matches dataset.
This table holds data for all entity matches. Use these datasets to view your entity match metadata.
| Field | Description | Data type/Mode |
|---|---|---|
| entityId | The unique entity identifier in Reltio. | Data type: STRING Mode: NULLABLE |
| timestamp | The time when an event is logged in Reltio. | Data type: NUMBER(13,0) Mode: NULLABLE |
| potential_matches | The entity's potential matches. It can have multiple rows depending on the number of matched entities. | Data type: VARIANT Mode: REPEATED |
| not_matches | The number of matches marked as not a match for the entity. It can have multiple rows depending on the number of matched entities. | Data type: VARIANT Mode: REPEATED |
| manual_matches | The entity's manual matches. It can have multiple rows depending on the number of matched entities. | Data type: VARIANT Mode: REPEATED |
| active | A value that indicates whether the match is currently active or not. | Data type: BOOLEAN Mode: REPEATED |
This table holds the entity's potential matches. It can have multiple rows depending on the number of matched entities.
| Field | Description | Data type/Mode |
|---|---|---|
| entityId | The unique entity identifier in Reltio. | Data type: STRING Mode: NULLABLE |
| matchRules | The list of match rules. | Data type: VARIANT Mode: REPEATED |
| matchScore | The match score configured as per the match rule. | Data type: NUMBER Mode: NULLABLE |
| relevanceScores | The list of relevance scores that contributed to the match. | Data type: VARIANT Mode: REPEATED |
This table holds the list of relevance scores that contributed to the match.
| Field | Description | Data type/Mode |
|---|---|---|
| matchRule | The match rule URI per the business configuration. | Data type: STRING Mode: NULLABLE |
| relevance | The relevance score configured as per the match rule. | Data type: NUMBER Mode: NULLABLE |
| actionLabel | The action label configured in match rule. | Data type: VARIANT Mode: NULLABLE |