Importing Relationships
You can configure a workflow to import relationships between records from a file directly to the Tamr RealTime System of Record (SOR). The workflow creates the relationships specified in the source, but does not update or delete existing relationships.
For example, depending on your use case your data may include relationships between members of the same household, or between company subsidiaries and headquarters.
Importing relationships to the SOR involves:
- Adding the relationships file or table as a source in Tamr Cloud.
- Configuring the workflow to import the relationships from the source.
- Running the workflow in the UI or via the API.
Adding the Relationships Source File
In Configurations > Sources, add the relationships source from a configured connection or direct upload. See Managing Sources for instructions.
Supported file format: NDJSON and CSV
Supported schema for the relationships source
Field | Data Type | Required |
---|---|---|
fromTableId | string | yes |
toTableId | string | yes |
fromRecordId | string | yes |
toRecordId | string | yes |
relationshipTypeId | string | yes |
details | JSON | no |
Configuring the Workflow to Import Relationships
Then add the workflow
- Navigate to Configurations > Workflows.
- Select New Workflow and then choose the Import Relationships workflow type.
- Enter a name for the workflow and select the source.
- Save the workflow.
Run the Workflow
You can run the workflow by either:
- Selecting the Play icon on the Workflows page.
- Using the Jobs API create operation to run the update workflow job. You must supply the
workflowId
which is available on the Workflows page.
Updated 1 day ago