- Extractors
- Analyze Data
Supported Fields for the Relationships Table
The following table provides the supported fields for the Relationships Table:
Column Name | Column Type | Description | Example |
|---|---|---|---|
externalId | varchar | The external ID of the relationship must be unique within the project. | extId |
sourceExternalId | varchar | The external ID of the resource that is the relationship source. | sourceExtId |
sourceType | varchar | The resource type of the relationship source. It must be one of the specified values. Enum:"asset""timeSeries""file""event""sequence" | asset |
targetExternalId | varchar | The external ID of the resource that is the relationship target. | targetExternalId |
targetType | varchar | The resource type of the relationship target. It must be one of the specified values. Enum: "asset" "timeSeries" "file" "event" "sequence" | asset |
startTime | timestamp | The time in milliseconds since Jan. 1, 1970, when the relationship became active. If there is no startTime, the relationship is active from the beginning of time until endTime. | 2024-12-04 09:48:11.929 |
endTime | timestamp | The time in milliseconds since Jan. 1, 1970, when the relationship became inactive. If there is no endTime, the relationship is active from startTime until the present or any point in the future. If endTime and startTime are set, the endTime must be greater than startTime. | 2024-12-04 09:48:11.929 |
confidence | double | Confidence value is the existence of the relationship. Generated relationships provide a score of the likelihood of the existing relationship. Relationships without a confidence value can be interpreted at the discretion of each project. | 0.7 |
dataSetId | bigint | The ID of the dataset the relationship belongs to. | 543000056769245 |
createdTime | timestamp | The time in milliseconds since Jan. 1, 1970, when the relationship was created. | 2024-12-04 09:48:11.929 |
lastUpdatedTime | timestamp | The time in milliseconds since Jan. 1, 1970, when the relationship was last updated. | 2024-12-04 09:48:11.929 |
Provide Feedback