The ClickHouse Data Pool enables you to read through to your self-hosted ClickHouse or ClickHouse Cloud rather than syncing data to Propel. This allows you to utilize the data in your analytic dashboards, reports, and workflows directly from your ClickHouse instance through the Propel APIs and UI components.
This setup is particularly effective when:
- You are running your own self-hosted ClickHouse database.
- You are using ClickHouse Cloud.
- You are building data applications and need an API on top of ClickHouse.
- You are building customer-facing analytics dashboards on top of ClickHouse.
- You need a PostgeSQL-compatible SQL interface on top of ClickHouse.
The ClickHouse Data Pool is in preview and requires an onboarding session. Please schedule an onboarding session with one of our engineers to get started.
ClickHouse Data Pools make queries directly to a table in your own ClickHouse and then serve the data via the API, SQL, or UI components.
ClickHouse Data Pools supports the following features:
|Reads through a ClickHouse table. The Propel user needs SELECT privileges.
|Batch delete operations are not supported on read-through Data Pools.
|Batch update operations are not supported on read-through Data Pools.
|Add column operations are not supported on read-through Data Pools.
|See API reference docs.
|See Propel Terraform docs.
How does the ClickHouse Data Pool work?
The ClickHouse Data Pool queries a table in your ClickHouse database using a set of credentials. The user provisioned for Propel must have at least
SELECT privileges that ensure real-time access to data.
Once created, a ClickHouse Data Pool is queryable via the API, SQL, or UI Components like any other Data Pool.
When you make changes to the underlying table, you can pick up those changes by creating a new Data Pool.
The table below describes the data types mappings from ClickHouse to Propel types. Types not supported by Propel will not be available in the Data Pool.
|Decimal (with 0 scale)
API reference documentation
Below is the relevant API documentation for the ClickHouse Data Pool.