Case Study: Dassana builds a security data lake with ClickHouse

Why they chose ClickHouse for their Security Data Lake which consolidates disparate data sources to provide contextualized data insights

Dassana, a security data lake and analytics company, needed a way to consolidate disparate security data sources and make sense of mutable security records that traditional SIEMs struggle to handle. Using ClickHouse, Dassana set out to normalize data from tools like CSPM and IDS so security teams could query contextualized insights such as SLA violations, remediation times, and alert status across business units.

ClickHouse provided the flexible storage and query capabilities Dassana needed, including ReplacingMergeTree, AggregatingMergeTree, materialized views, TTLs, external dictionaries, and asynchronous inserts. With ClickHouse, Dassana built a fast, schema-less security data lake that supports near real-time deduplicated results and lower costs; the company said ClickHouse cost a fraction of other big data systems and enabled them to store hundreds of millions of assets on a 32GB RAM box.

Dassana

Gaurav Kumar

Founder and CEO