Query announces the ClickHouse Cloud Connector in Preview!

ClickHouse is a high-performance, column-oriented SQL database management system (DBMS) for online analytical processing (OLAP). It is available as both an open-source software and a cloud offering. Analytics, also known as OLAP (Online Analytical Processing), refers to SQL queries with complex calculations (e.g., aggregations, string processing, arithmetics) over massive datasets. Unlike transactional queries (or OLTP, Online Transaction Processing) that read and write just a few rows per query and, therefore, complete in milliseconds, analytics queries routinely process billions and trillions of rows.

ClickHouse uses an asynchronous multi-master replication scheme to ensure that data is stored redundantly on multiple nodes. After being written to any available replica, all the remaining replicas retrieve their copy in the background. The system maintains identical data on different replicas. Recovery after most failures is performed automatically, or semi-automatically in complex cases.

ClickHouse implements user account management using SQL queries and allows for role-based access control configuration similar to what can be found in ANSI SQL standard and popular relational database management systems. ClickHouse supports a declarative query language based on SQL that is identical to the ANSI SQL standard in many cases. Supported query clauses include GROUP BY, ORDER BY, subqueries in FROM, JOIN clause, IN operator, window functions and scalar subqueries.

The Query Connector for ClickHouse Cloud will support any data in any table, view, or otherwise and support end-to-end query translation and normalization of data into the Query Data Model (QDM), based on the Open Cybersecurity Schema Framework. This will be a familiar approach to our Dynamic Connectors such as for Amazon OpenSearch Service, Amazon Security Lake, Redshift, and Snowflake. Given ClickHouse’s ability to support incredibly fast reads and writes, the Query Connector can help unlock near real-time insights from data in ClickHouse while lower volume or less important data can remain in data lakes or legacy SIEM products.

Stay tuned for when we make the driver Generally Available, we will update to provide the Documentation here.