6 karma · joined May 31, 2023
We agree - we currently have experimental support for JSON, but it is experimental and has some challenges. We're also working on a parallel track, to support semistructured columns (https://github.com/ClickHouse/ClickHouse/issues/54864). This is an alternative to the experimental JSON data type, that aims to address its drawbacks.
It’s also worth considering the comparative cost of Snowflake against other saas warehouses or databases, depending on your needs. For instance, we’ve heard from users that ClickHouse Cloud can be much more cost-effective for many use cases when compared to Snowflake - real-time analytics is a great example. For those who can’t build (or run OSS themselves), this is another interesting (and important) dimension. What's great about ClickHouse is that it's open source, too :).