Unify and manage your data

Show Page Sections

Split table datasets for Databricks Delta Lake

Learn about the datasets in the Split table for Databricks Delta Lake.

Entity table

This table lists the fields in this Delta Lake storage raw table.

FieldData TypeDescription
uristringThe entity Uri which consists of the <ObjectTypeSpecifier> Id
versionbigintThe version of objects in the Reltio system
timestampbigintThe time at which the event was logged
typestringThe entity type in Reltio system
attributes_<entityType>stringAll the attributes of the entity
crosswalksARRAY< STRUCT< type:string, uri:string, value:string, sourceTable:string, initialSource:ARRAY<string>, endInitialSource: STRING, startInitialSource: STRING, attributes:ARRAY<string>, createDate:string, reltioLoadDate:string, updateDate:string, deleteDate: STRING, singleAttributeUpdateDates:MAP<string, string>, crosswalkExternalInfo: STRUCT< dtssInfo: STRUCT< tenantId: STRING, operationId: STRING, matchReasons: ARRAY<STRING>, updatedBy: STRING, updatedTime: BIGINT, status: STRING, matchRuleUris: ARRAY<STRING> > > > >The crosswalk for the object
analyticsAttributes_<entityType>stringAll the analytical attributes of the entity
createdBystringThe creator of the entity
createdTimebigintTimestamp of the entity creation in the source system
updatedBystringThe ID of the person who made the last update
updatedTimebigintTimestamp of the last update of the entity in the source system
commitTimebigintThe commit time
deletedbooleanThe boolean value that indicates whether the entity is deleted or not
labelstringThe label of the entity
linkedbooleanThe boolean value that indicates whether the object is linked or have references to other objects
secondaryLabelstringThe secondary label of the entity
tagsarray<string>The tags of the entity
startDatebigintThe date when the entity was created in the Reltio system
endDatebigintThe date when the entity was soft deleted (if deleted) in the Reltio system

Relation table

This table lists the fields in this Delta Lake storage raw table.

FieldData TypeDefinition
uristringThe relation Uri which consists of the <ObjectTypeSpecifier> Id
typestringThe relation type in Reltio system
attributes_<relationType>stringAll the attributes of the relation
commitTimebigintThe commit time
createdBystringThe creator of the relation
createdTimebigintTimestamp of the relation creation in the source system
crosswalksARRAY< STRUCT< type:string, uri:string, value:string, sourceTable:string, initialSource:ARRAY<string>, endInitialSource: STRING, startInitialSource: STRING, attributes:ARRAY<string>, createDate:string, reltioLoadDate:string, updateDate:string, deleteDate: STRING, singleAttributeUpdateDates:MAP<string, string>, crosswalkExternalInfo: STRUCT< dtssInfo: STRUCT< tenantId: STRING, operationId: STRING, matchReasons: ARRAY<STRING>, updatedBy: STRING, updatedTime: BIGINT, status: STRING, matchRuleUris: ARRAY<STRING> > > > >The crosswalk for the object
deletedbooleanThe boolean value that indicates whether the relation is deleted or not
linkedbooleanThe boolean value that indicates whether the object is linked or have references to other objects
timestampbigintThe time at which the event was logged
updatedBystringThe ID of the person who made the last update
updatedTimebigintTimestamp of the last update of the relation in the source system
versionbigintThe version of objects in the Reltio system
startObjectSTRUCT< crosswalks:ARRAY< STRUCT< type:string, uri:string, value:string, sourceTable:string, initialSource:ARRAY<string>, endInitialSource: STRING, startInitialSource: STRING, attributes:ARRAY<string>, createDate:string, reltioLoadDate:string, updateDate:string, deleteDate: STRING, singleAttributeUpdateDates:MAP<string, string>, crosswalkExternalInfo: STRUCT< dtssInfo: STRUCT< tenantId: STRING, operationId: STRING, matchReasons: ARRAY<STRING>, updatedBy: STRING, updatedTime: BIGINT, status: STRING, matchRuleUris: ARRAY<STRING> > > > >, objectURI:STRING >The start object in a relation
startRefIgnoredbooleanThe boolean value if start object reference is ignored
startRefPinnedbooleanThe boolean value if start object reference is pinned
endObjectSTRUCT< crosswalks:ARRAY< STRUCT< type:string, uri:string, value:string, sourceTable:string, initialSource:ARRAY<string>, endInitialSource: STRING, startInitialSource: STRING, attributes:ARRAY<string>, createDate:string, reltioLoadDate:string, updateDate:string, deleteDate: STRING, singleAttributeUpdateDates:MAP<string, string>, crosswalkExternalInfo: STRUCT< dtssInfo: STRUCT< tenantId: STRING, operationId: STRING, matchReasons: ARRAY<STRING>, updatedBy: STRING, updatedTime: BIGINT, status: STRING, matchRuleUris: ARRAY<STRING> > > > >, objectURI:STRING >The end object in a relation
endRefIgnoredbooleanThe boolean value if the end object reference is ignored
endRefPinnedbooleanThe boolean value if the start object reference is pinned
startDatebigintThe date when the entity was created in the Reltio system
endDatebigintThe date when the entity was soft deleted (if deleted) in the Reltio system

Interactions table

This table lists the fields in this Delta Lake storage raw table.

FieldData TypeDescription
uristringThe interaction Uri which consists of the <ObjectTypeSpecifier> Id
versionbigintThe version of objects in the Reltio system
timestampbigintThe time at which the event was logged
typestringThe interaction type in Reltio system
deletedbooleanThe boolean value that indicates whether the interaction is deleted or not
attributes_<interactionType>stringAll the attributes of the interaction
crosswalksARRAY< STRUCT< type:string, uri:string, value:string, sourceTable:string, initialSource:ARRAY<string>, endInitialSource: STRING, startInitialSource: STRING, attributes:ARRAY<string>, createDate:string, reltioLoadDate:string, updateDate:string, deleteDate: STRING, singleAttributeUpdateDates:MAP<string, string>, crosswalkExternalInfo: STRUCT< dtssInfo: STRUCT< tenantId: STRING, operationId: STRING, matchReasons: ARRAY<STRING>, updatedBy: STRING, updatedTime: BIGINT, status: STRING, matchRuleUris: ARRAY<STRING> > > > >The crosswalk for the object
membersMAP< STRING, STRUCT< uri: STRING, type: STRING, members: ARRAY<MAP<STRING, STRING> > >The memberTypes (roles like "Chefs") with concrete entities which plays these roles in this interaction.
createdBystringThe creator of the interaction
createdTimebigintTimestamp of the interaction creation in the source system
updatedBystringThe ID of the person who made the last update
updatedTimebigintTimestamp of the last update of the relation in the source system
commitTimebigintThe commit time