JSON columns datasets for Databricks Delta Lake

Learn about the datasets in JSON storage format for Databricks Delta Lake.

Entity table

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


Field	Data Type
uri	string
version	bigint
timestamp	bigint
type	string
attributes	string
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> > > > >
analyticsAttributes	string
createdBy	string
createdTime	bigint
updatedBy	string
updatedTime	bigint
commitTime	bigint
deleted	boolean
label	string
linked	boolean
secondaryLabel	string
tags	array<string>
startDate	bigint
endDate	bigint

Relation table

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


Field	Data Type
uri	string
type	string
attributes	string
commitTime	bigint
createdBy	string
createdTime	bigint
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> > > > >
deleted	boolean
linked	boolean
timestamp	bigint
updatedBy	string
updatedTime	bigint
version	bigint
startObject	STRUCT< 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 >
startRefIgnored	boolean
startRefPinned	boolean
endObject	STRUCT< 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 >
endRefIgnored	boolean
endRefPinned	boolean
startDate	bigint
endDate	bigint

Interactions table

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


Field	Data Type
uri	string
version	bigint
timestamp	bigint
type	string
deleted	boolean
attributes	string
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> > > > >
members	`MAP<STRING, STRUCT< uri: STRING, type: STRING, members: ARRAY<MAP<STRING, STRING>> > >`
createdBy	string
createdTime	bigint
updatedBy	string
updatedTime	bigint
commitTime	bigint

Matches table

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


Field	Data Type
entityId	string
manual_matches	`array<struct<entityId:string>>`
not_matches	`array<struct<entityId:string>>`
potential_matches	`array< struct< entityId:string, matchRules:array<string>, matchScore:string> >`
version	bigint
deleted	boolean
timestamp	bigint
insertedTime	bigint

Merges table

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


Field	Data Type
winnerId	string
loserId	string
mergeKey	string
type	string
deleted	boolean
mergeRulesUris	array<string>
matchRules	array<string>
insertedTime	bigint
version	bigint
timestamp	bigint

Links table

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


Field	Data Type
winnerId	string
loserId	string
deleted	boolean
insertedTime	bigint
version	bigint
timestamp	bigint

Activity table

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


Field	Data Type
activityClientType	string
activityID	string
activityMethod	string
activitySource	string
activityTimestamp	bigint
activityUrl	string
activityUser	string
activityDescription	string
activityLabel	string
items	`ARRAY<STRUCT<data: STRING, delta: STRING, eventId: STRING, eventType: STRING, id: STRING, objectLabel: STRING, objectType: STRING, objectUri: STRING, startObjectUri: STRING, startObjectLabel: STRING, endObjectUri: STRING, endObjectUriLabel: STRING>>`
ingestTime	timestamp

Workflow table

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


Field	Data Type
uri	string
timestamp	bigint
environmentName	string
tenantId	string
objectURIs	string
resourceURIs	string
processInstanceID	string
taskID	string
processType	string
taskType	string
processInstanceCreateTime	bigint
taskCreateTime	bigint
username	string
assignee	string
processInstanceDueDate	bigint
decision	string
userActivityTime	bigint
processInstanceComplete	Boolean
processInstanceCompletionTime	bigint
processSuspended	Boolean
comment	The comments provided by users for a task workflow process. A new row is added to the table for each comment added by the user.

Accelerate the Value of Data

JSON columns datasets for Databricks Delta Lake

Entity table

Relation table

Interactions table

Matches table

Merges table

Links table

Activity table

Workflow table

Footer