Insights
Latest Thinking From The Team

May 27, 2025
General
Simplifying Your Data Stack With ClickHouse Cloud
Enterprise data and analytics platforms can be complex and expensive to operate. Businesses often find themselves running multiple…

May 26, 2025
General
Analysing FIX Data With ClickHouse
The Financial Information eXchange (FIX) Protocol is a standard that is used extensively within the capital markets industry to exchange…

Apr 22, 2025
Load And Performance Testing Your ClickHouse Deployment With K6
K6 is an open source tool for load and performance testing. It allows you to simulate a number of virtual users that interact with your…

Feb 28, 2025
General
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 3 - Demo
In this series of articles we are going to demonstrate how to reliably replicate data from PostgreSQL to ClickHouse. In part one , we…

Feb 28, 2025
General
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 2 - ClickPipes For PostgreSQL CDC
In this series of articles we are going to demonstrate how we can reliably replicate data from PostgreSQL to ClickHouse. In part one , we…

Feb 27, 2025
General
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 1 - PeerDB Open Source
In this series of articles we are going to demonstrate how we can reliably replicate data from PostgreSQL to ClickHouse. In part one , we…

Mar 30, 2024
General
Using Cube And ClickHouse To Power Data Applications In Financial Services
Last week we delivered a webinar with the Cube team, covering why we believe that Cube is an excellent fit for building data-oriented…

Sep 5, 2024
General
Time Series Classification Using ClickHouse Machine Learning Functions
This article is part of a series where we look at doing data science work within ClickHouse . Articles in this series include forecasting…

Jul 26, 2024
Tools
Building A Recommendation System Using ClickHouse and SQL
In recent blog posts we demonstrated how data science techniques such as forecasting and anomaly detection can be implemented entirely…

Jul 11, 2024
General
Linear Regression Using Clickhouse Machine Learning Functions
This article is part of a series where we look at doing data science work within ClickHouse . Articles in this series include forecasting…

May 23, 2024
General
Comparing ClickHouse Cloud With Snowflake Pricing
Introduction In this article we analyse the differences in pricing between Snowflake and ClickHouse Cloud , with the aim of comparing TCO…

Mar 15, 2024
General
Combining ClickHouse Cloud And AWS SageMaker For Machine Learning
In previous articles, we looked at performing machine learning tasks such as forecasting and anomaly detection directly within…

Mar 8, 2024
General
Calculating Value At Risk For An Equities Portfolio Using ClickHouse
ClickHouse is increasingly being used by capital markets firms such as investment banks, hedge funds and trading technology vendors…

Feb 14, 2024
General
Why Cloud Data Warehouses Are Too Expensive For Emerging Data Requirements
ClickHouse recently published an excellent article describing how cloud data warehouses such as Snowflake and Redshift are coming under…

Feb 7, 2024
Tools
Solving A Workforce Optimisation Problem With ClickHouse Cloud and Google OR-Tools
In a recent blog post we looked into a data science problem involving optimising how to route delivery vehicles around the country in the…

Jan 28, 2024
Anomaly Detection Using ClickHouse
This article is part of a series where we look at doing data science work within ClickHouse . Articles in this series include forecasting…

Jan 28, 2024
Tools
Using ClickHouse Cloud As A Real Time Data Warehouse
When you think of data warehouse technology, you may think of legacy on premise offerings such as Oracle or Terradata, or more modern cloud…

Jan 28, 2024
Machine Learning
Using ClickHouse Cloud To Power ML Feature Stores - A Fraud Detection Example
In a recent blog post we walked through the process of combining AWS SageMaker with ClickHouse to develop and deploy a machine learning…

Jan 28, 2024
General
Optimising Vehicle Routing Using ClickHouse Cloud And Google OR-Tools
Operational Analytics is about using real time data to make better day to day decisions. It involves looking at the state of the world…

Jan 28, 2024
ClickHouse
Combining dbt And ClickHouse
dbt is a popular open-source tool that is used for defining and running data transformations within data warehouses. Typically, it has…

Jan 28, 2024
General
Why ClickHouse Cloud Disrupts The Data Warehouse Industry
In recent years, when I have been asked by businesses which data warehouse to choose, there were 3 candidates at the top of the list…

Jan 17, 2024
General
How ClickHouse Cloud Simplifies Your Data Stack
In recent years, many data teams bought into the modern data stack tooling and philosophy. This involved combining a number of fully…

Jan 17, 2024
General
Open Table Formats Are Inevitable For Analytical Datasets
How open data formats such as Iceberg, Delta and Hudi are a compelling approach for businesses.

Dec 8, 2023
General
ClickHouse Cloud And Hex Are A Great Stack For Analytics And Data Science
ClickHouse Cloud and Hex are fast becoming our preferred stack for doing data analytics and data science. Together, they provide a fully…

Oct 15, 2023
General
Forecasting Using ClickHouse Machine Learning Functions
This article is part of a series where we look at doing data science work within ClickHouse . Articles in this series include forecasting…

Oct 12, 2023
ClickHouse
How We Built A Crypto Analytics Platform Based On ClickHouse
One of our most significant projects with ClickHouse involved developing an analytics platform for Crypto and Web3 data. The aim of the…

Jun 8, 2023
Ensemble CI
Using Git Branches And Pull Requests As Part Of Your dbt Workflow
How using source control, Git and branching and merging strategies can improve your data delivery.

May 5, 2023
General
How dbt Helps Data Engineers Work Like Software Engineers
How dbt helps Data Engineers adopt practices that have traditionally been used by Software Engineers

Jan 1, 2023
ClickHouse
Why We Went "All In" On ClickHouse
Historically, enterprise data and analytics systems have been built around batch processing. This involves collecting new data into batches…