Hightouch is a Reverse ETL tool that allows you to sync data from your Data Warehouse (Snowflake, BigQuery, etc.) out to other SaaS tools. We support syncing data from Hightouch using their Webhook destination.
You need to start by setting up an Inbound Webhook in Variance. You can find that on your Integrations page. You'll click Add Connection and then give your connection a name and choose whether it will be for Accounts, Contacts, or Events.
From there you'll get a page with some options, as well as the details you'll need to put into Hightouch.
To quickly take you through the page from top to bottom:
Ok, so now let's go into Hightouch.
In Hightouch go to Destinations > Add Destination and search for Webhook.
From here choose Webhook and hit Continue and you'll be asked for a Webhook URL and headers.
For Webhook URL, you will want to copy the Webhook URL from your Variance inbound webhook settings and for Headers, you'll type `Authorization` and then hit Add key, which will allow you to copy the Authorization header value from Variance. Finally hit Continue and you'll be asked for a name for your webhook and a slug. Once you do that, hit Continue again to save.
Great. Now the Destination should be set up and we just need to configure it as part of a Sync.
Now you'll have lots of options to choose from. These will really depend on how you intend to use Variance with this data, so we can't tell you exactly what to configure. If you have questions or need help, you can always reach out.
But no matter what the options are, we're going to want to start by running a test so you can configure everything in Variance. Remember: your Webhook is not currently writing data in Variance, so you don't need to worry about syncing bad data. To run a test hit Test on your sync in Hightouch. This will bring up the test screen.
Hit Sync as added row and you should see a response like this:
From there we are going to hop back over to Variance, where we should now see that test data under Latest Payload.
Assuming that looks good, you'll want to hit the big Finish Setup button. This is where you are going to tell Variance how you want to associate accounts from Hightouch with accounts in Variance, same for contacts, and events.
For accounts it looks like this:
There are 4 options to configure here:
If you set up both ID and name, we will try ID first and fall back to name. Once you hit Save the Webhook will be toggled on, meaning data we receive will be written to Variance.
Since mapping Contacts includes some other options, let's quickly go through those as well:
Just like Accounts, you can match on ID and custom property, but you can also match on email for contacts.
The extra complication is that for contacts you may also map them to accounts, which requires using the same fields as we would see in a regular account sync.
Since Events are fundamentally different than contacts and accounts, you'll need to do a few more things to make them work properly. Here's the Event mapping config:
Let's run through the fields:
Now that everything is configured in Variance, all that's left is to turn on your Hightouch sync. Once you have everything set up there, you'll hit Continue and then choose the frequency to sync. Hit Continue to save your choice and everything should be good to go.