Skip to main content
New Introducing Orchestrator Learn more
Data Warehouse integration

ClickHouse + Conversion

Sync contacts, custom objects, and events from ClickHouse Cloud or self-hosted servers with scheduled SQL.

ClickHouse
Into Conversion
Conversion

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. 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. 2 Create a dedicated user with a strong password and readonly = 2, and grant it the role.
  3. 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. 4 Under Settings > CRM & Syncing > Connections, add a ClickHouse connection with the host, HTTPS port, database, username, and password, then create your syncs.

See Conversion with ClickHouse

Book a demo and we'll walk through the ClickHouse integration on a stack that looks like yours.