Can I change the join path that's generated in Interactive Mode?

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.

Screen Shot 2019-04-08 at 4.02.51 PM.png