Joining to other models
To unlock the power of multi-source Polytomic syncs, you will want to use the Join to other models option when creating source models. This will allow you to have multiple source models in a single destination sync.
As an example, if you have a PostgreSQL database with an organization_id field that is also in HubSpot, when creating a HubSpot Company model, you'll want to join on those shared field.
![Screen Shot 2022-02-17 at 11.44.42 AM.png 1080](https://files.readme.io/86545fc-Screen_Shot_2022-02-17_at_11.44.42_AM.png)
Later, when creating a sync you can reference both the HubSpot Company model fields and PostgreSQL model fields in the same sync.
![Screen Shot 2022-02-17 at 11.51.22 AM.png 1730](https://files.readme.io/f1ce0d4-Screen_Shot_2022-02-17_at_11.51.22_AM.png)
There is no need to circularly join two models together - one join is enough to link them together. In other words, joins are directionless.
When viewing a model, you can see which other model has joined itself to the model being viewed. For example, this shows that the HubSpot Companies model we were just modifying has a join specified in our HubSpot Deals model.
![Screen Shot 2022-02-17 at 11.54.59 AM.png 1122](https://files.readme.io/70d9355-Screen_Shot_2022-02-17_at_11.54.59_AM.png)
Updated over 2 years ago