Create Graph

View as Markdown

Graph Setup

After connecting your tables, the next step is to link them into a graph schema to enable predictions.

  • To begin, navigate to the Graph and click Create Graph.
  • Select the tables to include. As you add tables, you can view the graph on the right pane.
  • Click Next to proceed.

Create New Graph page with tables selected and the resulting schema shown on the right

Table Linkages

After tables are selected, link them by specifying key (ID) columns that define relationships between tables. These links help Kumo understand the structure of your data for making predictions.

  • Links – Connect a primary key column to another table’s foreign key column.
  • Backlinks – Appear when other tables reference this table, indicating outward relationships.

For an e-commerce dataset, you might link:

  • Customer ID between customers and transactions.
  • Transaction ID between transactions and articles.

Link configuration step showing each table's links and backlinks alongside the graph schema

Table Linkage Considerations

Kumo automatically suggests links matching column names across tables. These linkages appear as dotted lines in the graph visualization.

When creating table links, keep in mind:

  • Timestamps do not need manual linking. Kumo automatically detects them.
  • If two linked columns have different types, both are cast to strings. Ensure values still match after casting.
  • Rows with missing key values are ignored when creating linkages.
  • Rows with unmatched key values across tables are also ignored.

To adjust linkages:

  • Click Table Name to modify a forward link.
  • Select tables and column names to add links, or click the Delete icon to remove links.
  • Click Save Graph to finalize your schema.

Verifying Your Graph Linkages

After creating your graph, Kumo takes you to the graph detail page, where you can review connectivity metrics for your new graph.

The “Graph Link Health” table at the bottom of the page contains health metrics that display the match percentages between each pair of linked tables. Lower-than-expected percentages may be symptoms of poor data quality or incorrect column pairings.

Graph Link Health table showing match percentages between linked tables

If your graph is in line with expectations, click the Write Predictive Query button to create your predictive queries.

Modifying Tables When Creating or Updating Graphs

If you need to modify a table while building or editing a graph, you can do so directly from the Graph page without leaving the workflow. For example, set a missing primary key or create date, or adjust column selections.

On the graph schema shown above, click the Edit (pencil) icon on the header of the table you want to modify.

This opens the table’s edit modal, where you can make the necessary changes in place.

Table edit modal opened from the graph, showing the table's columns and preprocessing

Fixing Data Issues After Graph Creation

If you discover data quality issues after creating your graph:

  • Fix issues in your source data.
  • Kumo will automatically re-ingest and reconnect tables the next time you train a model.