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:
Table 1. Table 1: GBQ Entity Table
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