ClickHouse is a column-oriented database which enables high-performance querying of large amounts of data. Treefort can send the custom analytics we collect directly to your ClickHouse instance so you have total control over custom reports.
👉️ As a prerequisite before starting this guide, you'll need a ClickHouse instance running and reachable from the Internet. If you don't already have one, consider signing up with a hosted provider such as ClickHouse Cloud.
🚨 Treefort makes best-effort attempts to retry sending analytics events which fail to reach your ClickHouse instance, but you are responsible to ensure the connection details are correct and the ClickHouse database is reachable by us. We will automatically retry sending failed analytics event batches for at least 3 days, but if your ClickHouse database remains unreachable beyond that then the failed batches will be discarded. We cannot backfill analytics data that is lost due to an outage of your ClickHouse database.
Setup instructions
Fill in the Host, Username, Database, and Password fields using the values from your ClickHouse instance.
Click Save. This will validate the connection settings and immediately create the necessary Treefort tables in your ClickHouse database.
🚧 This integration will create tables within your ClickHouse database. It is recommended that you use an empty database for this integration rather than trying to share the database with other existing ClickHouse tables.