💠360 Data/Data Blending
Combine data from different data sources
Last updated
Combine data from different data sources
Last updated
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.' However, it's important to note that not all resources are sync able. For instance, SQL products like MySQL and PostgreSQL are not sync able, which means they can't be blended.
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.
When blending data sources, it's essential to understand that the process involves creating virtual tables rather than directly syncing the data. This means that we can only perform select operations on the blended data. While it provides flexibility in accessing and analyzing data from different sources, it's important to keep in mind that any modifications or updates made through blending are not reflected back to the original sources.
The sync parameters can be changed in the Sync options tab. To get there, click the three dots in the top left corner of your data source page: