Accelerate the Value of Data

Relationship dataset for the legacy data schema

Learn about the relationship dataset for the column-based schema.

This table holds data for all relationships. Use these datasets to view your relationship metadata.
FieldDescriptionData type/Mode
UriThe Universal resource identifier. It is in the format <ObjectTypeSpecifier>/Id

Example: For entities the ObjectTypeSpecifier is 'entities'

Uri =

Data type: STRING

Mode: NULLABLE

TypeThe entity type in Reltio.Data type: STRING

Mode: NULLABLE

IdThe entity identifier in Reltio.Data type: STRING

Mode: NULLABLE

createdTimeThe timestamp when the entity is created in Reltio.Data type: TIMESTAMP

Mode: NULLABLE

createdByThe user who created the entity.Data type: STRING

Mode: NULLABLE

updatedTimeThe timestamp when the entity is last updated in Reltio.Data type: TIMESTAMP

Mode: NULLABLE

updatedByThe user who last updated the entity.Data type: STRING

Mode: NULLABLE

deletedTimeThe time when the entity is deleted.Data type: TIMESTAMP

Mode: NULLABLE

deletedAn indicator that tells you whether the entity is deleted or not.Data type: BOOLEAN

Mode: NULLABLE

startDateThe date when the entity is created in Reltio.Data type: TIMESTAMP

Mode: NULLABLE

endDateThe date when the entity is marked for a soft delete, if it is already deleted, in Reltio. Data type: TIMESTAMP

Mode: NULLABLE

eventTimeThe time when an event is logged in Reltio.Data type: TIMESTAMP

Mode: NULLABLE

insertedTimeThe time when an entity is inserted in the GBQ table.Data type: TIMESTAMP

Mode: NULLABLE

versionTimeThe object version in Reltio.Data type: INTEGER

Mode: NULLABLE

conflictedAttributesThe location of all attributes that are currently not in the attributes schema. After the tables are deleted and data is resynchronized, these values are added to the attribute column in the attributes schema.Data type: STRING

Mode: NULLABLE

StartAn object that has one property ID of the start object in the relationship (start object configured in L3). You can access the property ID using Start.Id.Data type: RECORD

Mode: NULLABLE

EndAn object that has one property ID of the end object in the relationship (end object configured in L3). You can access the property ID using End.Id.Data type: RECORD

Mode: NULLABLE

crosswalksA representation of the crosswalks of an object in Reltio. Data type: RECORD

Mode: NULLABLE

tagsThe location of all tags that can be applied to the entity.Data type: STRING

Mode: REPEATED

attributes_HeadNursingThe location of the entity's attribute information in JSON format.Data type: JSON

Mode: NULLABLE

attributes_AffiliationThe location of the entity's analytical attribute information in JSON format.Data type: JSON

Mode: NULLABLE

The crosswalks schema duplicates the structure of a Reltio crosswalk.
FieldDescriptionGBQ type/GBQ mode
valueThe crosswalk value.GBQ type: STRING

GBQ mode: NULLABLE

attributesThe list of attribute Uris that belong to the crosswalk.GBQ type: STRING

GBQ mode: REPEATED

UriThe crosswalk's Universal resource identifier.GBQ type: STRING

GBQ mode: NULLABLE

createDateThe timestamp when the crosswalk is created in Reltio.GBQ type: TIMESTAMP

GBQ mode: NULLABLE

updateDateThe timestamp when the crosswalk is last updated in Reltio.GBQ type: TIMESTAMP

GBQ mode: NULLABLE

deleteDateThe timestamp when the crosswalk is deleted.GBQ type: TIMESTAMP

GBQ mode: NULLABLE

reltioLoadDateThe timestamp when the crosswalk is loaded in Reltio.GBQ type: TIMESTAMP

GBQ mode: NULLABLE

sourceThe crosswalk source.GBQ type: STRING

GBQ mode: NULLABLE

sourceTableThe crosswalk source table.GBQ type: STRING

GBQ mode: NULLABLE

refEntityOrRelationIdThe identifier of the entity or relation that is used as a source for the reference attribute.GBQ type: STRING

GBQ mode: NULLABLE

This schema shows the structure for all attribute types. It can have multiple attributes.
FieldDescriptionGBQ type/GBQ mode
<AttributeName1>The first attribute's name.GBQ type: RECORD

GBQ mode: REPEATED

<AttributeName2>The second attribute's name.GBQ type: RECORD

GBQ mode: REPEATED

<AttributeName3>The third attribute's name.GBQ type: RECORD

GBQ mode: REPEATED