bruin-data
ClickHouse support
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
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?
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
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.
ClickHouse support only MySQL/PostgreSQL protocol, but doesn't support MySQL/PostgreSQL SQL dialect.
Fiy everyone we are working on it and now we also have custom destinations that enable you to easily add what you want
