Relationship dataset for Snowflake
Learn about the relationship dataset.
This table holds data for all relationships. Use these datasets to view your relationship metadata.
| Field | Description | Data type/Mode |
|---|---|---|
| version | The relationship version in Reltio. | Data type: NUMBER Mode: NULLABLE |
| Uri |
The universal resource identifier. It is in the format <ObjectTypeSpecifier>/Id. Example: For relationships the | Data type: VARCHAR Mode: NULLABLE |
| type | The relationship type in Reltio. | Data type: VARCHAR Mode: NULLABLE |
| timestamp | The time when the event is created in Reltio. | Data type: NUMBER(13,0) Mode: NULLABLE |
| attributes | The location of the relationship's attribute information in JSON format. | Data type: VARIANT Mode: NULLABLE |
| crosswalks | A representation of the crosswalks of the relationship in Reltio. | Data type: VARIANT Mode: REPEATED |
| startObject | The information on the start object in the relationship configured in the L3 configuration. | Data type: VARIANT Mode: NULLABLE |
| endObject | The information on the end object in the relationship configured in the L3 configuration. | Data type: VARIANT Mode: NULLABLE |
| startRefPinned | The information on the pinned start reference object in the relationship configured in the L3 configuration. | Data type: BOOLEAN Mode: NULLABLE |
| startRefIgnored | The information on the ignored start reference object in the relationship configured in the L3 configuration. | Data type: BOOLEAN Mode: NULLABLE |
| endRefPinned | The information on the pinned end reference object in the relationship configured in the L3 configuration. | Data type: BOOLEAN Mode: NULLABLE |
| endRefIgnored | The information on the ignored end reference object in the relationship configured in the L3 configuration. | Data type: BOOLEAN Mode: NULLABLE |
| createdTime | The timestamp 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 timestamp 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 relationship is currently active or not. | Data type: BOOLEAN Mode: NULLABLE |