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:

  1. Adding the relationships file or table as a source in Tamr Cloud.
  2. Configuring the workflow to import the relationships from the source.
  3. 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

FieldData TypeRequired
fromTableIdstringyes
toTableIdstringyes
fromRecordIdstringyes
toRecordIdstringyes
relationshipTypeIdstringyes
detailsJSONno

Configuring the Workflow to Import Relationships

Then add the workflow

  1. Navigate to Configurations > Workflows.
  2. Select New Workflow and then choose the Import Relationships workflow type.
  3. Enter a name for the workflow and select the source.
  4. 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 workflowIdwhich is available on the Workflows page.

© 2025, Tamr, Inc. All rights reserved.

License Agreement | Privacy Policy | Data Security Policy| AI Chatbot Disclaimer