Bytetalks Ep. 1: Real-Time Analytics with Bytewax & ClickHouse

By Zander Matheson & Laura Funderburk

Welcome, everyone. In today’s video, we’ll guide you through the process of setting up streaming analytics using ClickHouse, a powerful real-time OLAP database, in combination with Bytewax. We’ll discuss the origins and benefits of ClickHouse, focusing on its column-oriented storage approach, which enhances speed and efficiency.

You’ll learn about practical use cases, such as clickstream analytics and financial data processing, and see a step-by-step demonstration of:

  • Installing the Bytewax ClickHouse connector

  • Setting up schemas and configurations in ClickHouse

  • Building and configuring a data flow in Bytewax

  • Transforming and merging data streams before ingestion into ClickHouse

  • Utilizing ClickHouse operators for optimized data processing.

Additional Resources:

If you're interested in more connectors, we'd love to hear your thoughts! Join the conversation in our Slack channel or fill out the connector form on our website. 🙂

Stay updated with our newsletter

Subscribe and never miss another blog post, announcement, or community event.

Previous post
Zander Matheson

Zander Matheson

CEO, Founder
Zander is a seasoned data engineer who has founded and currently helms Bytewax. Zander has worked in the data space since 2014 at Heroku, GitHub, and an NLP startup. Before that, he attended business school at the UT Austin and HEC Paris in Europe.

Laura Funderburk

Senior Developer Advocate
Laura Funderburk holds a B.Sc. in Mathematics from Simon Fraser University and has extensive work experience as a data scientist. She is passionate about leveraging open source for MLOps and DataOps and is dedicated to outreach and education.
Next post