ClickHouse's Query Condition Cache: Skip Granules You Don't Need to Read
ClickHouse caches the granules a predicate emptied, so a dashboard that runs the same query every 30 seconds stops paying for index analysis and skipped data.
Caching
ClickHouse's Query Result Cache: A Hash of the AST, Not the Text
ClickHouse caches query results by hashing the parsed query, not the text you typed, plus the settings and database that could change the answer.