Table Relationships

Manage joins, data models, columns, and entity relationships for tables

PUT /v1/tables/{id}/joins

PUT /v1/tables/{id}/joins

Java

import static org.openmetadata.sdk.fluent.Tables.*;

String tableId = "a1b2c3d4-e5f6-7890-abcd-ef1234567890";

// Add join information
Tables.addJoins(tableId, Map.of(
    "startDate", "2024-01-01",
    "dayCount", 30,
    "columnJoins", List.of(
        Map.of(
            "columnName", "id",
            "joinedWith", List.of(
                Map.of(
                    "fullyQualifiedName", "snowflake_prod.analytics.public.orders.customer_id",
                    "joinCount", 1542
                )
            )
        )
    )
));

// Set data model
Tables.setDataModel(tableId, Map.of(
    "modelType", "DBT",
    "description", "Customer dimension table built from raw events",
    "sql", "SELECT id, name, email, created_at FROM raw.customers WHERE active = true"
));

Response (Add Joins)

{
  "startDate": "2024-01-01",
  "dayCount": 30,
  "columnJoins": [
    {
      "columnName": "agent_id",
      "joinedWith": [
        {
          "fullyQualifiedName": "sample_data.ecommerce_db.shopify.dim_agent.agent_id",
          "joinCount": 1542
        }
      ]
    }
  ]
}

Table Relationships

Manage join information, data models, column listings, and entity relationships for tables.

Add Joins

PUT /v1/tables/{id}/joins

Record join information between this table and other tables.

id · string · required

UUID of the table.

startDate · string · required

Start date for the join period (ISO 8601 format).

dayCount · integer

Number of days the join data covers.

columnJoins · array · required

Array of column join records.

Show properties

columnName · string · required

Name of the column in this table.

joinedWith · array · required

Array of joined column references.

Show properties

fullyQualifiedName · string · required

FQN of the joined column (e.g., snowflake_prod.analytics.public.orders.customer_id).

joinCount · integer · required

Number of times this join was observed.

Set Data Model

PUT /v1/tables/{id}/dataModel

Set the data model (dbt or similar) associated with this table.

id · string · required

UUID of the table.

modelType · string · required

Type of data model: DBT, LookML.

description · string

Description from the data model.

sql · string

SQL query or transformation logic from the model.

columns · array

Column descriptions and metadata from the data model.

Get Columns

GET /v1/tables/{id}/columns

Retrieve column information with optional pagination.

id · string · required

UUID of the table.

limit · integer · default: "10"

Maximum number of columns to return.

offset · integer · default: "0"

Offset for pagination.

The Python Tables facade in 1.13.1 doesn’t wrap joins or data models. Use the REST requests in the cURL example.

PUT /v1/tables/{id}/joins

Java

import static org.openmetadata.sdk.fluent.Tables.*;

String tableId = "a1b2c3d4-e5f6-7890-abcd-ef1234567890";

// Add join information
Tables.addJoins(tableId, Map.of(
    "startDate", "2024-01-01",
    "dayCount", 30,
    "columnJoins", List.of(
        Map.of(
            "columnName", "id",
            "joinedWith", List.of(
                Map.of(
                    "fullyQualifiedName", "snowflake_prod.analytics.public.orders.customer_id",
                    "joinCount", 1542
                )
            )
        )
    )
));

// Set data model
Tables.setDataModel(tableId, Map.of(
    "modelType", "DBT",
    "description", "Customer dimension table built from raw events",
    "sql", "SELECT id, name, email, created_at FROM raw.customers WHERE active = true"
));

Response (Add Joins)

{
  "startDate": "2024-01-01",
  "dayCount": 30,
  "columnJoins": [
    {
      "columnName": "agent_id",
      "joinedWith": [
        {
          "fullyQualifiedName": "sample_data.ecommerce_db.shopify.dim_agent.agent_id",
          "joinCount": 1542
        }
      ]
    }
  ]
}

---

Returns

Add joins returns the join data associated with the table.

Set data model returns the updated table with data model attached.

Get columns returns a paginated list of column definitions.

---

Error Handling

Code	Error Type	Description
401	UNAUTHORIZED	Invalid or missing authentication token
403	FORBIDDEN	User lacks permission
404	NOT_FOUND	Table does not exist
400	BAD_REQUEST	Invalid join data or data model format