Flattening Crosswalks

Learn about extracting and flattening crosswalks into a custom view.

Crosswalks can be flattened to a separate custom view and queried similar to other views. You can use the SQL statement given below to create a simple view for crosswalks where each crosswalk is flattened and multiple crosswalk sources are extracted to separate rows.

//This is a view for crosswalks
create or replace view "entity_Crosswalks" as ( select individual."uri" as "Uri",
individual."type" as "Type",
individual."createdBy" as "CreatedBy",
individual."createdTime" as "CreatedTime",
individual."updatedBy" as "UpdatedBy",
individual."updatedTime" as "UpdatedTime",
crosswalk.value:"createDate" as "CrosswalkCreatedDate",
crosswalk.value:"reltioLoadDate" as "CrosswalkLoadDate",  
crosswalk.value:"updateDate" as "CrosswalkUpdateDate",   
crosswalk.value:"type" as "CrosswalkSource",  
crosswalk.value:"uri" as "CrosswalkUri",  
crosswalk.value:"value" as "CrosswalkValue"   
from "entities" individual,
lateral flatten(input => individual."crosswalks") crosswalk
);

For example, to find all entities with the entity type 'Individual', use the following query:

SELECT ...
FROM "entities"
WHERE "type" = "configuration/entityTypes/Individual"

You've found your way to a temporary environment. Content is not complete or final. Looking for Reltio documentation? Go to docs.reltio.com.

© 2024 The RELTIO® mark is a registered trademark of Reltio, Inc. in the United States and other countries; DataDriven and Reltio Data Cloud are trademarks of Reltio, Inc. Other names or marks are trademarks of their respective owners.

Terms, Privacy Policy, and

Unify and manage your data

Flattening Crosswalks

Footer