ClickHouse support

[Slach]

It would be great if your tool will add support for ClickHouse

[ChrisMcKee]

pretty much just passes through to https://dlthub.com/ library
so I guess it would need support in https://dlthub.com/docs/dlt-ecosystem/destinations/ first

[karakanb]

Kinda. While dlt destinations would be preferred, I could still add a Clickhouse custom destination without waiting on dlt having it, and then contribute it.

IIRC Clickhouse has a Postgres-compatible API, would that work in the meantime?

[e12e]

IIRC Clickhouse has a Postgres-compatible API, would that work in the meantime?

Have not tried it, but should work according to the documentation:

https://clickhouse.com/docs/en/interfaces/postgresql

And clickhouse can work with a number of sources directly, see eg examples for clickhouse local: https://clickhouse.com/docs/en/operations/utilities/clickhouse-local

[ChrisMcKee]

Kinda. While dlt destinations would be preferred, I could still add a Clickhouse custom destination without waiting on dlt having it, and then contribute it.

IIRC Clickhouse has a Postgres-compatible API, would that work in the meantime?

There's an issue on dlt about using ast to cover a wide range including click house.

[Slach]

ClickHouse support only MySQL/PostgreSQL protocol, but doesn't support MySQL/PostgreSQL SQL dialect.

[adrianbr]

Fiy everyone we are working on it and now we also have custom destinations that enable you to easily add what you want

[Slach]

@adrianbr great news

[adrianbr]

it was added to dlt btw :) forgot to keep you posted

[karakanb]

it is in our roadmap to bring it into ingestr as well, thanks Adrian!