When viewing a specific sync, you can view detailed run-level information. A run is a particular invocation of a sync, either triggered manually, via an API request, through an Airflow/dbt integration or via a schedule.
Each run provides the number of records processed, added, changed, removed, and rejected. If there were any errors, click the View Error button to view details related to the run.
For the added, changed, and removed columns the number of records successfully sent to the destination appears in green as the first column. The number of records attempted but not successfully completed are in the second red column.
For example, if a record was removed from the model, you will see a green 1 under the 'removed' column. If the record was not removed due to an error, you will see a red 1 instead under the same column.
By default, Hightouch keeps track of changes to your data between syncs. Consequently, an initial run of a sync will show many records 'added' and subsequent runs will, in many cases, show fewer records 'added' and instead, show many records have 'changed'. If you wish to reset the sync's tracking to its initial state -- as if it were syncing for the first time again -- you can select 'Resync full query' from the menu on your sync's main page:
When a record leaves your source--in other words, when your model no longer returns a record that was returned in the previous run of the sync--you can set your sync to one of two or three options (depending on the capabilities of the destination):
Do nothing. This will preserve the record in your destination. This is useful for when you want your destination to continually accrue records from your source.
Delete the destination record associated with the source record. This is useful for when you want your destination to exactly mirror your source by dropping records that have dropped out of your model.
Clear fields that are being synced to in the destination record, but do not delete. Use this option to retain records in your destination, but clear the fields that are mapped in your sync.
Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.
Connection issues with your data warehouse?
Confusing API responses from destination systems?
Unsupported destination objects or modes?
Help with complex SQL queries?
If you see something that's missing from our app, let us know and we'll work with you to build it!
We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.