Most of the destinations in Hevo are SQL data warehouses where the data is organized in tables. Due to the very basic nature of warehouses, they do not always support updating previously saved records. However, many of our users want to replicate mutable data into their warehouses for real-time analysis and therefore, being able to update previously saved records is important.
Hevo supports updating previously saved records through Primary Keys. If you define a primary key in a table in your destination, Hevo will do the following while loading a record in the destination table:
- If the record has the same Primary Key value as another record already present in the destination table, it will update the existing record with the new one.
- If the record has a Primary Key value not present in the destination table, it will append the record in the table.
Please note that the same is true when data is loaded through both a Pipeline or a Model.