ClickHouse Integration
Connect ClickHouse to sync user and account attributes into Enterpret. This adds customer context to feedback so you can analyze it using fields such as plan, industry, region, or account.
Before you begin
You’ll need:
A ClickHouse HTTPS endpoint that Enterpret can reach.
The database and table or view you want to sync.
A dedicated read-only ClickHouse user with
SELECTaccess to that table or view.One current row for each user or account, including the required columns below.
Required columns
Column names are case-sensitive.
Column | Requirement |
|---|---|
| A non-null |
| A non-null |
| A non-null |
Other supported columns in the table or view become attributes in Enterpret. For example, you can include fields such as name, plan, industry, or account_id.
Keep one current row per
ERC_ID. If your table stores multiple versions, connect a view that returns only the current row for each identifier.
Connect ClickHouse
1. Choose the integration type
In Enterpret, go to Settings → Integrations.
Select New Integration, choose ClickHouse, and select Continue.
Choose User Integration to sync people or Account Integration to sync companies.
Each integration connects to one ClickHouse table or view. Create separate integrations if your users and accounts are stored separately.
2. Enter the connection details
Field | What to enter |
|---|---|
ClickHouse Integration Name | A clear name, such as ClickHouse - Users or ClickHouse - Accounts. |
Host | Your HTTPS hostname without |
HTTPS Port | Your ClickHouse HTTPS port. ClickHouse Cloud commonly uses |
Database | The database containing the table or view. |
Table or View | The table or view containing the current user or account rows. |
Username | The dedicated read-only ClickHouse user. |
Password | The password for that user. |
3. Choose the initial import
Enable Import all history to import all current rows.
Disable it and select a start date if you only want to import rows from a specific date.
Set the Late-arrival Overlap window. Enterpret re-reads this period to capture delayed updates. The default is 60 minutes, and the maximum is 1440 minutes.
4. Validate and connect
Select Validate and Integrate. Enterpret checks the connection and required columns before creating the integration.
After the integration is created, review its sync status and the attributes discovered from your table or view.
5. Link customer context to feedback
After the first sync completes, use the integration’s linking section to match identifiers between your user, account, and feedback sources. The matching fields must contain the same identifier format.
Adding a field such as account_id makes it available as an attribute, but does not configure the link automatically.
Keep changes syncing
Keep
ERC_IDstable for each user or account.Preserve the original value of
ERC_CREATED_AT.Whenever an attribute changes, update
ERC_ROW_CREATED_ATto a later timestamp.
Enterpret uses ERC_ROW_CREATED_AT together with the overlap window to identify new and updated rows.
Troubleshooting
The connection cannot be validated
Check the hostname, HTTPS port, network access, credentials, and that the read-only user has SELECT access to the selected table or view.
The required columns are rejected
Confirm that the column names match exactly, use supported non-null types, and that ERC_ROW_CREATED_AT is DateTime64 with precision from 3 to 9.
Attributes are missing
Wait for the initial sync to complete and then check the discovered attributes again. If the sync is complete and attributes are still missing, contact Enterpret Support and include the integration name and any error shown.
User or account context is not linked to feedback
Review the matching fields in the linking section and confirm that both sources use the same identifier format.