Secoda and Hightouch Integration
The modern data stack has gone through an extremely rapid evolution over the past few years. Now, teams are adopting yet another new approach, reverse ETL, which moves data from a data warehouse or data lake back to the original system. Several new approaches are emerging, including "reverse ETL," the process of moving data from the data warehouse into third party systems in order to make data operational. Reverse ETL tools are a useful component of the stack for better conversion of data. Reverse ETL solutions are becoming a core piece of the data stack and in doing so, are becoming an essential part of a teams data knowledge.
As the leader in reverse ETL, Hightouch is the go to solution for companies like Kong, Plaid, Grafana, and Retool. It has a visual audience builder for non-data users, and you can quickly iterate without the help of engineers. We are extremely excited to announce our integration with Hightouch, which lets our customers document their reverse ETL in the same place as the rest of their data knowledge. By connecting Hightouch to Secoda, customers can see an overview of all their syncs in the Secoda dashboard. Once they click on a sync, they can easily the name of the sync and Secoda automatically documents the description of the sync based on the source and the destination. Additionally, by clicking on the "</>" icon beside a sync, customers will be able to see the query running in Hightouch directly in Secoda. This can help employees outside the data team understand how data is moving in-between different tools and what queries are being use to sync these tools. In the future, we hope to use some of this information for end to end lineage. Secoda also displays the history of syncs, allowing its users to understand the details behind each sync. Users are also able to attach documentation to any syncs in Secoda, and share them with any department or employee.
Continuing to expand Secoda's integrations with tools like Hightouch is important because the modern data stack is evolving rapidly and tools like Secoda must keep up with the modern data stack. Below is an overview of how you can set up your Hightouch integration with Secoda.
How to set up your integration
There are three steps to get started using Hightouch with Secoda:
- Retrieve a Hightouch session cookie
- Connect Hightouch to Secoda
Retrieve a Hightouch session cookie
Secoda uses the Hightouch GraphQL API, which requires a session cookie. To get a session cookie follow these steps:
1. Open up https://app.hightouch.io and login
2. Open up the developer tools by right clicking and selecting Inspect
3. Click the Network tab
4. Navigate to the "Syncs" page (refresh if you're currently on this page)
5. Click on the first graphql network request
6. Navigate to the Headers tab
7. Copy and save the set-cookie header to somewhere you can retrieve later. This is the "Cookie" parameter that Secoda requires
Connect Hightouch to Secoda
After retrieving the cookie, the next step is to connect Secoda:
- In the Secoda App, select ‘Add Integration’ on the Integrations tab
- Search for and select ‘Hightouch’
- Enter your Cookie. This information is kept encrypted.
- Click 'Connect'
- After the extraction is complete your Hightouch Syncs will be in Secoda
ready for you to document