Using Join Suggestions
In Metadata Insights, if you are using the Discovery module, the Joins page gives you suggestions (Join Suggestion tab). These suggestions are based on the primary and foreign key linkages in the tables you already discovered.
When you accept the suggestion, it displays in the Join Definition tab.
To use Join Suggestions, perform these steps: