Join relationship and links datasets to resolve winner entities

Learn how to join datasets exported from Reltio DPH to resolve outdated relationship references using the links dataset.

As a prerequisite, you need access to your DPH-target environment (e.g., Snowflake, Databricks, BigQuery) and availability of RELATIONS and LINKS datasets.

If your relationship table includes outdated URIs for merged entities, you can join it with the links dataset to resolve to current winner IDs.

Extract active records from the RELATIONS dataset:

WITH RelationData AS (
  SELECT
    r."uri",
    SPLIT_PART(r."startObject":objectURI::VARCHAR, '/', 2) AS start_object_id,
    SPLIT_PART(r."endObject":objectURI::VARCHAR, '/', 2) AS end_object_id,
    ...
  FROM RELTIO.RELATIONS r
  WHERE r."active" = 'TRUE'
)

Join with ACTIVELINKS to resolve to winner URIs:

SELECT
  rd."uri",
  COALESCE(so."winnerId", rd.start_object_id) AS startobject,
  COALESCE(eo."winnerId", rd.end_object_id) AS endobject,
  ...
FROM RelationData rd
LEFT JOIN RELTIO.ACTIVELINKS so ON rd.start_object_id = so."loserId"
LEFT JOIN RELTIO.ACTIVELINKS eo ON rd.end_object_id = eo."loserId"

Create a view or table from this query to use in downstream tools.

A dataset or view with current winner entity references in both start and end object fields, ensuring data integrity in relationship analysis and reporting across platforms.

Unify and manage your data

Join relationship and links datasets to resolve winner entities

Footer