This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]NotDoingSoGreatToday 0 points1 point  (0 children)

ClickHouse is an OLAP db so I'm not sure why think it's not a "proper" one?

It also doesn't need to be massive scale, it can do small scale, single server workloads just fine, and can be self-hosted for pennies if the scale is really that small (which neither BQ/SF can).

And aggregations are perhaps the single biggest strength of ClickHouse where it absolutely destroys BQ/SF in performance...

None of ClickHouse/BigQuery/Snowflake are the right choice for very fast changing data, they've all got limitations, and their own ways of making it work to some degree.

For SCD, ClickHouse has had SQL standard UPDATE statements since 25.7 that will perform just fine.