If you ever need to link two entities but don't know how, this will be your lifesaver!
Azimutt find-path will do a graph traversal following relations from one entity to the other and give you all the possible paths. And will even make the SELECT query with the correct JOINs for you 🥳
It's really great, but you will be surprised how many paths are possible, even with a short path 🤯
That's an issue with relational database which are heavily linked graphs, often with big hubs (like "users") that join any part of the graph with few links, even though they don't make sense.
To avoid that, we added settings to ignore some tables and columns and make this search more useful:
By default, the "created_by", "updated_by" and "deleted_by" attributes are ignored, but you may want to adjust that for your case. It's often an iterative process to remove entities and attributes you don't want from the results to reduce it until it's small enough, and you found your way.
Find-path is accessible from the top right bolt or on any entity context menu (right-click on the header).