Using Data stores
Learn how to use data stores to share data between automations.
When handling data between two or more automations, a data store is required. This can be useful when dealing with large data sets or needing the same data in many places and looking for ways to centralize the external data request or providing greater efficiency.
The most common use case is centralizing data pulling from an external source and providing it to multiple other automations, e.g.:
- Google Sheets
- Tableau
- Google Analytics
- BigQuery
- Appsflyer
- Adjust
- Any other API
How to set up, update, and retrieve data stores
Set-Up a Data Store
When you’re in the main overview view, click Data Stores in the left navigation. Then hit “New Data Store, add an identifier, an optional schema and any data.
Update a data store
In order to set or update a data store, we can use the Update Data Store node. We simply select the data store we want to update by its id and pass it the new data.
Retrieve a data store
To retrieve a variable and use its value, we can use the Fetch Data Store node. We need to select the data store by id and the node will return its current value.
Patch a data store
To change the value or add data to a data store without updating it entirely, use the Patch Data Store node. We need to select the data store by its id and add any patches.
Similar to the Patch JSON node, this example will add a field parameter to the existing data store.
Last updated on September 9, 2023