3 ms·
Agreed, I wouldn't use Clickhouse for usual warehouse stuff either, mostly because I can't imagine it plays well with dbt which is a non-starter these days. I'
by claytonjy 5y ago
Agreed, I wouldn't use Clickhouse for usual warehouse stuff either, mostly because I can't imagine it plays well with dbt which is a non-starter these days.
I'd still argue Clickhouse is closer to Snowflake/Redshift than anything OLTP, and their name is intentionally chosen to evoke warehouse-like scenarios.
- FridgeSeal 5y agoWhat makes you think CH doesn’t like joins? Having used Redshift, Snowflake and CH for similar workloads, I’d much prefer ClickHouse to the other 2. Snowflake is hideously expensive for the subpar perf it offers in my experience and Redshift is mediocre at best in general.
- hodgesrm 5y agoIs your comment on ClickHouse and DBT based on using the DBT ClickHouse plugin? [0] If so I would be very interested in understanding what you or others see as deficiencies. [0] https://github.com/silentsokolov/dbt-clickhouse https://github.com/silentsokolov/dbt-clickhouse
- david38 5y agoClickhouse is nothing like snowflake. A Postgres user can be useful in Clickhouse in minutes, not even close for snowflake.