ClickHouse
Case Studies
ClickHouse: The Backbone of Dassana's Security Data Lake
Overview
ClickHouse: The Backbone of Dassana's Security Data LakeClickHouse |
Application Infrastructure & Middleware - Event-Driven Application Cybersecurity & Privacy - Cloud Security | |
Electrical Grids National Security & Defense | |
Cybersecurity Tamper Detection | |
System Integration Training | |
Operational Impact
ClickHouse has provided Dassana with a flexible and cost-effective solution for managing their security data. The different table engines allow Dassana to store data in a format that suits their use case, and the ability to insert data frequently using asynchronous inserts has simplified their operations. The in-built accounting system helps them track query costs, and the automatic data movement to different storage tiers has saved them development time. The advanced external dictionary options have enabled them to achieve better performance as their data grew. However, they also learned that ClickHouse needs to be handled with care and attention to detail, and they recommend using ClickHouse Cloud for managing the complexity of scaling and replicating data. | |
Quantitative Benefit
ClickHouse costs a fraction of what other big data systems would cost Dassana. | |
ClickHouse's in-built storage tier system has saved Dassana precious development time. | |
Dassana can store hundreds of millions of assets (distinct record_id) data on a 32GB RAM box. | |