appsmithorg
[Feature]: Add support for Clickhouse
Is there an existing issue for this?
- [X] I have searched the existing issues
Summary
Add support for Clickhouse as a data source.
Why should this be worked on?
ClickHouse is growing in popularity and is already used by companies like Uber, EBay, Spotify and Cloudflare. It supports best in the industry query performance, while significantly reducing storage requirements through our innovative use of columnar storage and compression.
@funge thank you for this feature request! Unfortunately, we are backed up right now with improving the experience of a whole bunch of our existing data sources. We'll be sure to prioritize this if this gets more attention :)
Sort of making this work with the clickhouse http rest API but it would be nice to have true query support.
The postgresql wire protocol interface does not work with Appsmith, unfortunately.
While we're waiting, I was able to get Appsmith talking to a Clickhouse on-premise system by setting up the Clickhouse MySQL interface and using Clickhouse as a MySQL data source. It won't load the schema for you in Appsmith: it probably doesn't like Clickhouse data types, but the queries work fine against the Clickhouse DB. Some Clickhouse data types generate errors - e.g. Bool generates an overflow error, so needs to be cast to int (0 or 1).
