Landing table datasets for Snowflake
Learn about the landing table dataset.
Note: Null values are allowed for all fields.
| Field | Description | Data Type | Primary key/Unique key |
|---|---|---|---|
| uri | The universal resource identifier. It is in the format <ObjectTypeSpecifier>/Id. Example: For entities the | VARCHAR | No/No |
| timestamp | The time when the entity is created in Snowflake. If data is synced between Reltio and Snowflake, the time of the sync is also displayed here. | NUMBER | No/No |
| deleted | A value that indicates whether the entity is deleted or not. | BOOLEAN | No/No |
| linked | A value that indicates whether the entity is linked or has references to another entity. | BOOLEAN | No/No |
| objectType | The type of object. For example, the object type for an entity is ObjectType is ENTITY and the object type for a relation is RELATION. | VARCHAR | No/No |
| type | The entity type. | VARCHAR | No/No |
| json | The complete entity with all the attributes in JSON format. | VARIANT | No/No |