Insights
Sharing knowledge and lessons learnt based on my ClickHouse engagements.
-
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 3 - DemoBenjamin Wootton
February 7, 2025
A video walkthrough of PeerDB open source and ClickPipes for Postgres CDC.
Read More
-
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 2 - ClickPipes For PostgreSQL CDCBenjamin Wootton
January 24, 2025
Using ClickPipes to reliably replicate data from PostgreSQL to ClickHouse.
Read More
-
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 1 - PeerDB Open SourceBenjamin Wootton
January 23, 2025
Using PeerDB open source to reliably replicate data from PostgreSQL to ClickHouse.
Read More
-
Time Series Classification Using ClickHouse Machine Learning FunctionsBenjamin Wootton
September 5, 2024
An example of how we can classify time series by leveraging machine learning functions baked into ClickHouse.
Read More
-
Optimising Vehicle Routing Using ClickHouse Cloud And Google OR-ToolsBenjamin Wootton
August 20, 2024
Operational Analytics is about using real time data to make better day to day decisions
Read More
-
Building A Recommendation System Using ClickHouse and SQLBenjamin Wootton
July 26, 2024
In recent blog posts we demonstrated how data science techniques such as forecasting and anomaly detection can be implemented entirely within ClickHouse using only SQL.
Read More
-
Linear Regression Using Clickhouse Machine Learning FunctionsBenjamin Wootton
July 11, 2024
Using functions integrated into ClickHouse to implement a linear regression.
Read More
-
Load And Performance Testing Your ClickHouse Deployment With K6Benjamin Wootton
June 10, 2024
We’ve recently used K6 to directly load test a ClickHouse environment and found it to be very powerful and expressive.
Read More
-
Comparing ClickHouse Cloud With Snowflake PricingBenjamin Wootton
May 23, 2024
In this article we analyse the differences in pricing between Snowflake and ClickHouse Cloud
Read More
-
Anomaly Detection Using ClickHouseBenjamin Wootton
April 22, 2024
This article is part of a series where we look at doing data science work within ClickHouse
Read More
-
Using Cube And ClickHouse To Power Data Applications In Financial ServicesBenjamin Wootton
March 30, 2024
Last week we delivered a webinar with the Cube team, covering why we believe that Cube is an excellent fit for building data-oriented applications.
Read More
-
Combining ClickHouse Cloud And AWS SageMaker For Machine LearningBenjamin Wootton
March 15, 2024
Machine learning professionals can learn how to combine ClickHouse Cloud and AWS SageMaker for powerful data analytics and predictive modeling. This comprehensive guide demonstrates end-to-e...
Read More
-
Calculating Value At Risk For An Equities Portfolio Using ClickHouseBenjamin Wootton
March 8, 2024
ClickHouse is increasingly being used by capital markets firms such as investment banks, hedge funds and trading technology vendors.
Read More
-
Why Cloud Data Warehouses Are Too Expensive For Emerging Data RequirementsBenjamin Wootton
February 14, 2024
The cost model behind many cloud data warehouses is not defined for low latency big data workloads.
Read More
-
Solving A Workforce Optimisation Problem With ClickHouse Cloud and Google OR-ToolsBenjamin Wootton
February 7, 2024
As a professional services firm, we have a workforce allocation or optimisation problem. In this article we demonstrate how to solve this problem using ClickHouse Cloud and Google OR-Tools.
Read More
-
Using ClickHouse Cloud As A Real Time Data WarehouseBenjamin Wootton
January 28, 2024
When you think of data warehouse technology, you may think of legacy on premise offerings such as Oracle or Terradata, or more modern cloud based platforms such as Snowflake, AWS Redshift or...
Read More
-
Using ClickHouse Cloud To Power ML Feature Stores - A Fraud Detection ExampleBenjamin Wootton
January 22, 2024
A feature store is a place to store the cleaned and prepared input data that we use to train a machine learning model
Read More
-
How ClickHouse Cloud Simplifies Your Data StackBenjamin Wootton
January 17, 2024
How ClickHouse cloud has the potential to take complexity out of your data stack.
Read More
-
Why ClickHouse Cloud Disrupts The Data Warehouse IndustryBenjamin Wootton
January 15, 2024
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
Read More
-
ClickHouse Cloud And Hex Are A Great Stack For Analytics And Data ScienceBenjamin Wootton
December 8, 2023
Two of our favourite tools which combine to be a brilliant serverless stack for data and analytics.
Read More
-
Forecasting Using ClickHouse Machine Learning FunctionsBenjamin Wootton
October 15, 2023
This article is part of a series where we look at doing data science work within ClickHouse
Read More
-
How We Built A Crypto Analytics Platform Based On ClickHouseBenjamin Wootton
October 12, 2023
A walkthrough of our architecture for DeFi analytics platform.
Read More
-
Combining dbt And ClickHouseBenjamin Wootton
June 17, 2023
Learn how to effectively combine dbt and ClickHouse for data transformation and analytics. Discover best practices, use cases, and implementation strategies for leveraging dbt's transformati...
Read More
-
Why We Went "All In" On ClickHouseBenjamin Wootton
June 1, 2023
ClickHouse is a uniquely differentiated database which we decided to take a big bet on.
Read More
