It should take only 5 minutes!
Reminder: Only admins can connect a new data source!
Go to your Data Sources page in the Settings
Select ClickHouse in the list of data providers
It will open a modal.
Fill in the connection form
Start by giving this new data source a relevant
display name. It will help you identify this data source in Husprey.
Enter server information
database, as well as your credentials,
password. You can also choose to use
HTTPS (learn more about it below).
Note that these credentials will be used for all queries run in Husprey. If you rather want each analyst to use their own personal set of credentials, please contact us so that we can activate the appropriate option on your workspace.
How we connect to ClickHouse
Husprey connects to your ClickHouse data warehouse via its HTTP interface.
By default, we use HTTPS, but you can deactivate that security setting in the connection form.
Read more about ClickHouse HTTP interface
You should now be good to go! As soon as the first data model sync finished, you can run your first query 🥳
If you experience any issue while trying to connect to your data source, please ensure that your firewall accepts incoming requests from the following IP addresses:
In any case, do not hesitate to contact us directly on firstname.lastname@example.org so we can help you out connecting your data source in Husprey.