Entity datasets for Snowflake
Learn about the entity datasets.
This table holds data for all entities. Use these datasets to view your entity metadata.
| Field | Description | Data type/Mode |
|---|---|---|
| Uri | The universal resource identifier. It is in the format <ObjectTypeSpecifier>/Id. Example: For entities the | Data type: VARCHAR Mode: NULLABLE |
| version | The entity version in Reltio. | Data type: NUMBER Mode: NULLABLE |
| timestamp | The time when the event is created in Reltio. | Data type: NUMBER(13,0) Mode: NULLABLE |
| attributes | The attributes that are configured in the business configuration. | Data type: VARIANT Mode: NULLABLE |
| crosswalks | A representation of the crosswalks of an object in Reltio. | Data type: VARIANT Mode: NULLABLE |
| createdTime | The time when the entity is created in Reltio. | Data type: NUMBER Mode: NULLABLE |
| createdBy | The user who created the entity. | Data type: VARCHAR Mode: NULLABLE |
| updatedTime | The time when the entity is last updated in Reltio. | Data type: NUMBER Mode: NULLABLE |
| updatedBy | The user who last updated the entity. | Data type: VARCHAR Mode: NULLABLE |
| startDate | The date when the entity is created in Reltio. | Data type: NUMBER Mode: NULLABLE |
| endDate | The date when the entity is marked for a soft delete, if it is already deleted, in Reltio. | Data type: NUMBER Mode: NULLABLE |
| active | A value that indicates whether the entity is currently active or not. | Data type: BOOLEAN Mode: NULLABLE |
| Field | Description | Data type/mode |
|---|---|---|
| uri | The universal resource identifier. It is in the format <ObjectTypeSpecifier>/Id. Example: For entities the | Snowflake type: VARCHAR Snowflake mode: NULLABLE |
| timestamp | The time when the event is created in Reltio. | Snowflake type: NUMBER(13,0) Snowflake mode: REPEATED |
| deleted | A value that indicates whether the event is deleted or not. | Snowflake type: BOOLEAN Snowflake mode: NULLABLE |
| linked | A value that indicates whether the entity is linked to another entity or not. | Snowflake type: BOOLEAN Snowflake mode: NULLABLE |
| version | The entity version in Reltio. | Snowflake type: NUMBER Snowflake mode: NULLABLE |
| json | A representation of the JSON object in Reltio. | Snowflake type: VARIANT Snowflake mode: NULLABLE |
| endDate | The date when the entity is marked for a soft delete, if it is already deleted, in Reltio. | Snowflake type: NUMBER Snowflake mode: NULLABLE |