If you have foreign keys set up in your database, Chartio is able to auto-generate join paths in Interactive Mode. Chartio will try to find the shortest path between tables, but this may not always be the join path you want to use.
Adjusting the join path in Interactive Mode
In Interactive Mode, add a filter using a column from the table you want to route the join path through. Choose a non-nullable column (e.g. the primary key) and filter by
is not null. This will force the join path to be generated through the desired table.
Alternatively, you can click on the “Regenerate Join” button that appears when previewing the SQL to switch to the desired join path.