First, make sure that you are signed into your company’s Tableau Server (10.3+) so that you can leverage the recommendations engine. Next, connect to a database of interest. In this case, I will be looking at the Postgres database for this Tableau Server.
Once I am connected, I can see all of the tables in this database, as well as five recommended ones. Looking at the recommended tables tab shows me which tables are most popular in my organization.
Now I can find the table I need (in this case, the _workbooks table), and Tableau will recommend other related tables. These are tables that others have joined to mine in the past.
When I add a new table to the data prep area, Tableau uses previously seen join conditions to smartly pick which field names and join direction to use for the join.
In this case, Tableau chooses the most popular join condition used to join these two tables together. If your database has foreign keys defined, Tableau will use those to perform a join, instead of previously seen join conditions.
This functionality is available for most, but not all connectors. We will be adding support for new connectors in the order of their popularity. If you would really like to see recommendations on your connector, let us know in the comments or Ideas forum on the Community!