💠360 Data/Data Blending

Combine data from different data sources

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.

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.

pageSync Connection

Blending the data

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.

pageBlending the Data

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.

Sync options

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:

pageSync Options