Table Links

A link records that a column in one table refers to a column in another — an order's customer_id pointing at a customer's id.

Links are what let you expand from one table into a related one on the canvas, and they are how the shape of your data is described rather than just its contents.

Creating one

  1. Select a table on the canvas and open Links.
  2. Choose Add table link.
  3. Pick the column on each side. The app spots likely matches — "Looks like a match. Hit the link button to add your first pair."
  4. Add the pair.

Composite links — where the relationship needs more than one column on each side — are built by adding more pairs to the same link.

For a link into a list column, a single membership pair is the whole link: "A membership pair (value in list) makes the whole link — no further pairs."

The link direction can be swapped, and clicking again resets it.

Both tables must be in the model

You can only link tables that are both present in the model you are working in. If the other end lives elsewhere, the app says so: "Other endpoint lives in a different model. Import that table here to use this link."

Import the table first, then make the link.

Authority comes from the pair of tables, never from one of them. That is the rule to hold on to: a link is a fact about two tables, so no single table's permissions can settle it.

The floor, for every link: you must be able to see both tables. If you cannot, you cannot create the link, delete it, or even know it exists — and the refusal deliberately tells you nothing about the table you cannot see, not even what kind it is.

Above that floor:

The pairWho may create or delete
Two ordinary tablesAnyone who can edit either one
An ordinary table and a catalog tableAnyone who can edit the ordinary side
Two catalog tablesA catalog manager

Importing a table gives you no link rights over it. Being able to read a published catalog table does not let you rewrite the catalog's link graph — that belongs to whoever edits the table, not to everyone who imported it.

Link health checks whether a link's values actually line up — whether the referring values are found on the other side.

It becomes available once the table is released; before that the app says "Link health is available once the table is released."

Moving a table to another organization can sever links, and you are told how many before you confirm.

A link is severed when the destination organization would not grant access back to the other endpoint — in other words, when the other end stays behind in an organization that can no longer see the table. Links whose other end is in the destination organization, in the catalog, or in a third organization survive, and a link from a table to itself travels with it.

The count shown in the confirmation is exactly the set that will be removed.

Deleting

Delete table link removes it, and the confirmation says it cannot be undone. The tables and their data are untouched — only the relationship between them goes.