.png)
Connect to our datawarehouse
Do you want to integrate the data from Hello Customer with data from other sources in your own dashboards? Do you want to find a way to easily get the data out of Hello Customer without having to do manual exports all the time? Do not search any longer! You can set up a connection to our Datawarehouse to make this possible.
PAID MODULE
The connection to our Datawarehouse is a paid option. Do not hesitate to talk about this to your account manager and / or customer success manager!
IN THIS ARTICLE
1. Set up a Snowflake account
Before you can connect to our Datawarehouse, you will need a Snowflake account.
If you do not have a Snowflake account yet, make sure to set it up
- On Azure
- In the Europe West region
You do not need to purchase a yearly license, but you do need to create an on-demand Snowflake account and link it to a credit card. You will only be charged based on the amount of queries you do. More information on how to set up a Snowflake account can be found on their own website.
If you already have an account and it doesn't meet the parameters above, it is still possible to connect to our Datawarehouse. Contact your customer success manager or support@hellocustomer.com to discuss the options.
2. Data Model
The data in our Datawarehouse is structured in a data model. Of course, you can only see the data linked to your own company. This model contains information about:
- Participant transactions: this table contains data about the transactions of the participants. One record represents a participant during a single transaction (i.e. when submitting a survey).
- Answers: this table holds all of the questions and their respective answers
- ISAAC predictions: this table holds the data about ISAAC’s individual prediction items. One verbatim can contain multiple prediction items, thus multiple records in this table. A prediction item can in turn consist of multiple prediction lines (the “regarding”)
- Email stats: this table contains data about the email statistics. We display the latest status for a participant in this table.
- Conversation manager: This table contains notes and tags added in the conversation manager.
A detailed description per column can be found in this pdf file.
3. Ingest the data in your data warehouse / storage buckets
Not only can you build your dashboards directly on the Snowflake data share, you can also choose to import the data in your existing data warehouse or data lake. Depending on your internal data stack, there are multiple ways to transfer the data to your system of choice.
- Snowflake's documentation holds clear explanations on how one can easily export the data to a cloud bucket on one of the three main cloud providers. This is often used as an intermediary step.
- We've seen examples of clients setting up their Snowflake account as a linked server in order to query Snowflake from sql server.
- Tools as Fivetran and Azure Datafactory are gaining a lot of traction for easy data-transfer with just a few clicks. We've also seen examples of companies leveraging SSIS.