360 Data allows you to connect and sync more than 30 data sources to your Jet app. Jet syncs your data sources to Jet Tables which allows you to join(merge) data and write SQL with non-SQL data sources.
You can even layer the above capabilities to transform your data the way you want regardless of where it comes from.
All the data sources you want to be able to blend from have to be connected through the "Sync connection"
While connecting a data source, you'll be prompted to choose the type of connection, there could be a direct connection or a sync connection.
To demonstrate how the data blending works, we'll use two data sources: Airtable and Google Sheets, where the former contains the Order table and the latter - the Customers table. Notice that the Customer ID column in the Orders table refers to the ID in the Customers table.