Insights
Sharing knowledge and lessons learnt based on my ClickHouse engagements.
-
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