Entity Table Structure
In the MDM tenant, when an entity is created, updated or deleted, a new record with
all the data is written into a partition and the date is appended using the
eventTime
parameter.
The GBQ entity table contains the following data:
- MDM tenant data
- Event data (information about the event that generated the GBQ record)
- Attribute data
- Crosswalk data
Note:
- The data that is older than seven days is compacted. After compaction only the latest record is available.
insertedTime
is an internal field.
The Table 1: GBQ Entity Table contains the following data:
Field name | Type | Mode |
---|---|---|
crosswalks | RECORD | REPEATED |
crosswalks. value | STRING | NULLABLE |
crosswalks. attributes | STRING | REPEATED |
crosswalks. Uri | STRING | NULLABLE |
crosswalks. updatedDate | TIMESTAMP | NULLABLE |
crosswalks .deleteDate | TIMESTAMP | NULLABLE |
crosswalks. reltioLoadDate | TIMESTAMP | NULLABLE |
crosswalks. source | STRING | NULLABLE |
crosswalks. sourceTable | STRING | NULLABLE |
crosswalks. createDate | TIMESTAMP | NULLABLE |
crosswalks. refEnitytOrRelationId | STRING | NULLABLE |
tags | STRING | REPEATED |
createdTime | TIMESTAMP | NULLABLE |
updatedTime | TIMESTAMP | NULLABLE |
insertedTime | TIMESTAMP | NULLABLE |
startDate | TIMESTAMP | NULLABLE |
endDate | TIMESTAMP | NULLABLE |
Uri | STRING | NULLABLE |
updatedBy | STRING | NULLABLE |
Type | STRING | NULLABLE |
createdBy | STRING | NULLABLE |
eventTime | TIMESTAMP | NULLABLE |
versionTime | INTEGER | NULLABLE |
deleted | BOOLEAN | NULLABLE |
deletedTime | TIMESTAMP | NULLABLE |
Id | STRING | NULLABLE |
attributes | RECORD | NULLABLE |
attributeName | RECORD | NULLABLE |
attribute. value | RECORD | NULLABLE |
attribute. Id | STRING | NULLABLE |
attribute. isOv | BOOLEAN | NULLABLE |