With Equals, it's easy to combine data across your connected datasources. For example, you could combine data from Stripe and Salesforce in the same spreadsheet to perform deeper analyses.

There are two ways to join data in Equals:

The Query builder allows you to combine data from different tables in your connected databases (e.g. Postgres, redshift) or across connected cloud apps (e.g. Stripe, Segment) without using SQL.

Once your datasources are connected, you can create a new query in a workbook using the query builder or start with a saved query.

Select Join data and specify the connection you'd like to set up. An example could be joining between one Postgres table and another Postgres table, or it could be joining a Stripe table with a HubSpot table. You'll want to specify the column that is the same in each datasource for the join to work. For example, the ID in Stripe should match the ID in HubSpot.

Note that the query from each datasource will need to have the column shared by both sources selected.

Combine data across datasources by writing traditional SQL against connected Fivetran datasources.

To get started, connect a datasource to a sheet in your workbook and select the SQL Editor. Then, to view the fields you want to join, open the table browser and select the additional datasource you want to join.

Here's an example of connecting subscription data from Stripe with product usage data from Segment.

The query builder can join across any datasource, including saved queries (if the saved queries were generated using the query builder). The SQL editor can join across Fivetran-powered datasources, listed below:

In the query builder, you can choose the type of join you want to set up:

The SQL editor only supports Left Joins.