New Destination: ClickHouse

[josepowera]

Tell us about the new integration you’d like to have

Which source and which destination?
ClickHouse (https://clickhouse.tech/) - https://github.com/ClickHouse/ClickHouse
Clickhouse goes in same direction as Snowflake, but is OpenSource. Handles billinons of rows without problem.

JDBC driver is available (https://github.com/ClickHouse/clickhouse-jdbc)

Integration as Source and as Destination would be highly welcome.

┆Issue is synchronized with this Asana task by Unito

[michel-tricot]

Thank you @josepowera !

Agreed that it would make great addition to the connectors. The fact that it has a jdbc driver should make the first version trivial to create since we have an existing Jdbc base for both destinations & sources.

Would you be interested in taking a crack at it? We can guide you through the process of creating a new connector.

[kunaldawn]

need the same!

[subodh1810]

@josepowera @kunaldawn hey can you share which clickhouse version are you using?

[subodh1810]

I have created #3317 to track clickhouse source integration.
We will have a separate issue for clickhouse destination integration

[josepowera]

v21.3.9.83-lts

[subodh1810]

hey @josepowera thanks for letting me know the version. I just merged the PR for implementation of clickhouse as a source
Ref : #3361 and #3375
Look for it in the next release cycle. Keep tracking this current issue for updates on clickhouse as destination

[bindu29]

need clickhouse has destination connector

[sajanpummer]

Looking for this connector.

[everysize]

ClickHouse would be a milestone for Airbyte! I've evaluated a lot of ELT/ETL-services and until now none of them supports ClickHouse as destination. Airbyte may could profit as first-mover. Clickhouse is awesome and a lot of big companies already use it (e.g. Cloudflare, Spotify, ebay, Uber, ebay, Deutsche Bank).

They recently received $50M invest and I think more companies will migrate to ClickHouse.

See also:
https://blog.cloudflare.com/http-analytics-for-6m-requests-per-second-using-clickhouse/
https://www.ewdn.com/2021/09/22/yandex-teams-up-with-top-us-funds-to-commercialize-database-management-solutions/