Why are the match counts not reconciling between Snowflake and Reltio MDM?

Question

Our Snowflake Connector is not syncing the data between Reltio and Snowflake currently. We can see discrepancies in match count & hence an investigation is needed. 

Snowflake Query

select  matchRules.value::STRING Matchrule , count(*)
from  "matches",
LATERAL flatten( INPUT => "potential_matches",
OUTER => TRUE ) POTENTIAL_MATCHES,
LATERAL flatten(INPUT => POTENTIAL_MATCHES.value:matchRules,
OUTER => TRUE) matchRules
  group by 1
  order by 2 desc;
 

Result of Snowflake Query

image.png

Result of MDM Search

docusign.png

 

Answer

Execute the following synchronization task

POST https://{env}.reltio.com/reltio/api/{tenantID}/syncToDataPipeline?distributed=true&taskPartsCount=4

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.