How Conversion works with ClickHouse
Conversion connects to ClickHouse Cloud or self-hosted ClickHouse over HTTPS and runs the SQL queries you write on a schedule you choose. Each row lands as a contact, a custom object related to a contact, or an event that can trigger a workflow. Conversion signs in as a dedicated read-only user, so it can run SELECT queries but can't write to your databases.
What syncs
| Data | Direction | Details |
|---|---|---|
| Contacts | Into Conversion | Created or updated from each row, identified by userId or email, with columns mapped to field keys by exact name. |
| Custom objects | Into Conversion | Any custom object type you define, related to contacts through relationshipFields built as a named tuple. |
| Events | Into Conversion | Rows become timestamped events on contacts, and an eventId stops a repeated row from being recorded twice. |
How to connect ClickHouse
- 1 In the ClickHouse Cloud SQL console or clickhouse-client, create a role with SELECT and SHOW on the database you want to sync.
- 2 Create a dedicated user with a strong password and readonly = 2, and grant it the role.
- 3 Add Conversion's IP addresses to the service's IP Access List in ClickHouse Cloud, or allow them through your firewall on the HTTPS port if you self-host.
- 4 Under Settings > CRM & Syncing > Connections, add a ClickHouse connection with the host, HTTPS port, database, username, and password, then create your syncs.