Skip to main content

Point Axi at the whole connection, and let it find the joins

Axi answered about the table you had open, because that was the only thing it could be told about. A picker above the message box now says what it is looking at — This table, or Whole connection — and a sweep no longer needs you to type "continue".

Say what Axi is looking at​

Switch the picker to Whole connection and Axi stops looking at the open table altogether: the chips collapse to the connection's name, the suggestions become the connection-wide ones, and "set the foreign keys on this connection" is answered by sweeping the tables that need them rather than the one you happen to be standing on.

The choice stays where you put it while you move between tables, metrics and relationships — a sweep that re-narrowed itself the moment you clicked Show on a proposal would be no use. It goes back to This table when you switch connections.

Tables that join to nothing now count as unfinished​

A table could have a description and a primary key and still join to nothing, because its customer_id and store_id columns were never declared — and Axi had no way to find it. Undeclared foreign keys are now a gap like any other: they show up in a sweep, and a new suggestion, Set up the keys of this connection, starts one. Every key is still checked on your data before it is proposed.

Continue in one click​

The last proposal card of a batch now carries a Continue button with what is left — Continue with 12 tables left. Batches of five, reviewed one card at a time, are unchanged; only the retyping is gone.

📖 Modelling with Axi · Keys and joins