Product

Enterprise

Docs

Pricing

About

Blog

Contact

Start building

BLOG

Boost your knowledge

with Glassflow

Stay informed about new features, explore use cases, and learn how to build real-time data pipelines with GlassFlow.

ClickHouse Learnings

Real-Time Deduplication for ClickHouse: Solving Duplicate Events Before Ingestion

Remove duplicate events before they reach ClickHouse.

Written by

Armend Avdijaj

Jan 30, 2026

ClickHouse Learnings

Real-Time Deduplication for ClickHouse: Solving Duplicate Events Before Ingestion

Remove duplicate events before they reach ClickHouse.

Written by

Armend Avdijaj

ClickHouse Learnings

Real-Time Deduplication for ClickHouse: Solving Duplicate Events Before Ingestion

Remove duplicate events before they reach ClickHouse.

Written by

Armend Avdijaj

ClickHouse Learnings

Kafka to ClickHouse breaks quietly in AI systems

Learn how AI systems push Kafka to ClickHouse beyond what most pipelines were built for.

Written by

Armend Avdijaj

ClickHouse Learnings

Kafka to ClickHouse breaks quietly in AI systems

Learn how AI systems push Kafka to ClickHouse beyond what most pipelines were built for.

Written by

Armend Avdijaj

Tutorials

Guide to Build an Observability Stack with OpenTelemetry and Kafka

Build a complete observability pipeline from telemetry to insights.

Written by

Armend Avdijaj

Tutorials

Guide to Build an Observability Stack with OpenTelemetry and Kafka

Build a complete observability pipeline from telemetry to insights.

Written by

Armend Avdijaj

ClickHouse Learnings

ClickHouse Deduplication with ReplacingMergeTree: How It Works and Limitations

ReplacingMergeTree deduplication in ClickHouse – and its limitations.

Written by

Armend Avdijaj

ClickHouse Learnings

ClickHouse Deduplication with ReplacingMergeTree: How It Works and Limitations

ReplacingMergeTree deduplication in ClickHouse – and its limitations.

Written by

Armend Avdijaj

ClickHouse Learnings

Real-Time Deduplication with GlassFlow: A Better Alternative to ReplacingMergeTree

Deduplication with GlassFlow: Fixing the limits of ClickHouse merges

Written by

Armend Avdijaj

ClickHouse Learnings

Real-Time Deduplication with GlassFlow: A Better Alternative to ReplacingMergeTree

Deduplication with GlassFlow: Fixing the limits of ClickHouse merges

Written by

Armend Avdijaj

Comparisons

GlassFlow vs ClickPipes for Deduplication

We compared GlassFlow and ClickPipes for ClickHouse deduplication

Written by

Armend Avdijaj

Comparisons

GlassFlow vs ClickPipes for Deduplication

We compared GlassFlow and ClickPipes for ClickHouse deduplication

Written by

Armend Avdijaj

ClickHouse Learnings

Understanding ClickHouse’s AggregatingMergeTree Engine: Purpose-Built for High-Performance Aggregations

Understand and compare ClickHouse’s AggregatingMergeTree engine

Written by

Divyanshu Raj

ClickHouse Learnings

Understanding ClickHouse’s AggregatingMergeTree Engine: Purpose-Built for High-Performance Aggregations

Understand and compare ClickHouse’s AggregatingMergeTree engine

Written by

Divyanshu Raj

Observability

Real-Time Observability with ClickHouse, Coroot & GlassFlow

Open-source observability stack: ClickHouse, GlassFlow & Coroot.

Written by

Armend Avdijaj

Observability

Real-Time Observability with ClickHouse, Coroot & GlassFlow

Open-source observability stack: ClickHouse, GlassFlow & Coroot.

Written by

Armend Avdijaj

Observability

Building a Next-Gen Observability Stack with ClickStack and GlassFlow

Open source observability with ClickStack and GlassFlow

Written by

Armend Avdijaj

Observability

Building a Next-Gen Observability Stack with ClickStack and GlassFlow

Open source observability with ClickStack and GlassFlow

Written by

Armend Avdijaj

Observability

Observability in the AI Era: Scaling Logs with ClickHouse & GlassFlow

How ClickHouse powers observability at AI scale: Fast, efficient and ready for growth

Written by

Armend Avdijaj

Observability

Observability in the AI Era: Scaling Logs with ClickHouse & GlassFlow

How ClickHouse powers observability at AI scale: Fast, efficient and ready for growth

Written by

Armend Avdijaj

Comparisons

Top 6 Kafka Alternatives

When Kafka fits and when alternatives make sense.

Written by

Armend Avdijaj

Comparisons

Top 6 Kafka Alternatives

When Kafka fits and when alternatives make sense.

Written by

Armend Avdijaj

Comparisons

Snowflake vs ClickHouse: Choosing the Right Analytics Platform

Compare Snowflake and ClickHouse for modern analytics.

Written by

Armend Avdijaj

Comparisons

Snowflake vs ClickHouse: Choosing the Right Analytics Platform

Compare Snowflake and ClickHouse for modern analytics.

Written by

Armend Avdijaj

Migrations

Migrating from Snowflake to ClickHouse

Migrating from Snowflake to ClickHouse: Step-by-Step Guide

Written by

Armend Avdijaj

Migrations

Migrating from Snowflake to ClickHouse

Migrating from Snowflake to ClickHouse: Step-by-Step Guide

Written by

Armend Avdijaj

Comparisons

Redshift vs ClickHouse: Choosing the Right Analytics Platform

Compare Amazon Redshift and ClickHouse for modern analytics.

Written by

Armend Avdijaj

Comparisons

Redshift vs ClickHouse: Choosing the Right Analytics Platform

Compare Amazon Redshift and ClickHouse for modern analytics.

Written by

Armend Avdijaj

Migrations

Migrating from Redshift to ClickHouse

Migrating from Redshift to ClickHouse: Step-by-Step Guide

Written by

Armend Avdijaj

Migrations

Migrating from Redshift to ClickHouse

Migrating from Redshift to ClickHouse: Step-by-Step Guide

Written by

Armend Avdijaj

Migrations

Migrating from Bigquery to ClickHouse

Migrating from Bigquery to ClickHouse: Step-by-Step Guide

Written by

Armend Avdijaj

Migrations

Migrating from Bigquery to ClickHouse

Migrating from Bigquery to ClickHouse: Step-by-Step Guide

Written by

Armend Avdijaj

ClickHouse Learnings

ClickHouse JOINs Explained: Types, Examples & Best Practices

Learn ClickHouse JOINs step by step: types, examples & best practices.

Written by

Armend Avdijaj

ClickHouse Learnings

ClickHouse JOINs Explained: Types, Examples & Best Practices

Learn ClickHouse JOINs step by step: types, examples & best practices.

Written by

Armend Avdijaj

ClickHouse Learnings

Clickhouse and Its Limitations with JOINS

Clickhouse and the limitations when it comes to JOINS

Written by

Armend Avdijaj

ClickHouse Learnings

Clickhouse and Its Limitations with JOINS

Clickhouse and the limitations when it comes to JOINS

Written by

Armend Avdijaj

ClickHouse Learnings

Why Denormalization is Not the Answer to Reducing Joins in ClickHouse

Why denormalization slows down ClickHouse and what to do instead.

Written by

Armend Avdijaj

ClickHouse Learnings

Why Denormalization is Not the Answer to Reducing Joins in ClickHouse

Why denormalization slows down ClickHouse and what to do instead.

Written by

Armend Avdijaj

ClickHouse Learnings

How to Solve JOIN Limitations in ClickHouse

Struggling with JOINs in ClickHouse? Learn how to handle them efficiently.

Written by

Armend Avdijaj

ClickHouse Learnings

How to Solve JOIN Limitations in ClickHouse

Struggling with JOINs in ClickHouse? Learn how to handle them efficiently.

Written by

Armend Avdijaj

Tutorials

Tutorial: How to Solve JOIN Limitations in ClickHouse with GlassFlow

Solve ClickHouse JOIN limitations with GlassFlow.

Written by

Armend Avdijaj

Tutorials

Tutorial: How to Solve JOIN Limitations in ClickHouse with GlassFlow

Solve ClickHouse JOIN limitations with GlassFlow.

Written by

Armend Avdijaj

ClickHouse Learnings

ClickHouse Query Optimization: Best Practices for Faster Queries

Speed up ClickHouse queries using keys, indexes, dedup & JOIN optimization

Written by

Armend Avdijaj

ClickHouse Learnings

ClickHouse Query Optimization: Best Practices for Faster Queries

Speed up ClickHouse queries using keys, indexes, dedup & JOIN optimization

Written by

Armend Avdijaj

ClickHouse Learnings

Materialized Views in ClickHouse: Benefits, Limitations, and Alternatives

Materialized Views in ClickHouse: Benefits and Limits

Written by

Armend Avdijaj

ClickHouse Learnings

Materialized Views in ClickHouse: Benefits, Limitations, and Alternatives

Materialized Views in ClickHouse: Benefits and Limits

Written by

Armend Avdijaj

ClickHouse Learnings

Overcoming the Limits of Materialized Views in ClickHouse with GlassFlow

How to fix common problems with Materialized Views in ClickHouse

Written by

Armend Avdijaj

ClickHouse Learnings

Overcoming the Limits of Materialized Views in ClickHouse with GlassFlow

How to fix common problems with Materialized Views in ClickHouse

Written by

Armend Avdijaj

ClickHouse Learnings

Data Lakes, Apache Iceberg, and ClickHouse: Solving Data Transformation Challenges

From data lakes to ClickHouse: mastering real-time data transformation.

Written by

Armend Avdijaj

ClickHouse Learnings

Data Lakes, Apache Iceberg, and ClickHouse: Solving Data Transformation Challenges

From data lakes to ClickHouse: mastering real-time data transformation.

Written by

Armend Avdijaj

Tutorials

No-Code Clickhouse ETL with Glassflow

Set up real-time ETL pipelines to ClickHouse with GlassFlow and Docker.

Written by

Vimalraj Selvam

Tutorials

No-Code Clickhouse ETL with Glassflow

Set up real-time ETL pipelines to ClickHouse with GlassFlow and Docker.

Written by

Vimalraj Selvam

Tutorials

No-Code Clickhouse ETL with Glassflow - Dedup

Deduplicate streaming logs before ClickHouse-no code, no duplicates.

Written by

Vimalraj Selvam

Tutorials

No-Code Clickhouse ETL with Glassflow - Dedup

Deduplicate streaming logs before ClickHouse-no code, no duplicates.

Written by

Vimalraj Selvam

Tutorials

No-Code Clickhouse ETL with Glassflow - Join

Joining Kafka Streams Before ClickHouse with GlassFlow

Written by

Vimalraj Selvam

Tutorials

No-Code Clickhouse ETL with Glassflow - Join

Joining Kafka Streams Before ClickHouse with GlassFlow

Written by

Vimalraj Selvam

Comparisons

Best managed clickhouse services in 2025

Managed ClickHouse services compared by features, pricing and use case.

Written by

Armend Avdijaj

Comparisons

Best managed clickhouse services in 2025

Managed ClickHouse services compared by features, pricing and use case.

Written by

Armend Avdijaj

ClickHouse Learnings

Simplify Cloudflare’s Log Analytics Setup with GlassFlow

Simplify Cloudflare’s ClickHouse log analytics with GlassFlow: faster, cleaner.

Written by

Armend Avdijaj

ClickHouse Learnings

Simplify Cloudflare’s Log Analytics Setup with GlassFlow

Simplify Cloudflare’s ClickHouse log analytics with GlassFlow: faster, cleaner.

Written by

Armend Avdijaj

Tutorials

Kafka to ClickHouse® Made Simple with Glassflow and Altinity.Cloud

Simplify Kafka-to-ClickHouse Pipelines with GlassFlow and Altinity.Cloud

Written by

Armend Avdijaj

Tutorials

Kafka to ClickHouse® Made Simple with Glassflow and Altinity.Cloud

Simplify Kafka-to-ClickHouse Pipelines with GlassFlow and Altinity.Cloud

Written by

Armend Avdijaj

ClickHouse Learnings

Asynchronous Inserts in ClickHouse Explained

Understand asynchronous inserts in ClickHouse with a practical example.

Written by

Armend Avdijaj

ClickHouse Learnings

Asynchronous Inserts in ClickHouse Explained

Understand asynchronous inserts in ClickHouse with a practical example.

Written by

Armend Avdijaj

Comparisons

From Kafka to ClickHouse: Understanding Integration Methods and Their Challenges

Which Kafka-to-ClickHouse method is right for your stack?

Written by

Armend Avdijaj

Comparisons

From Kafka to ClickHouse: Understanding Integration Methods and Their Challenges

Which Kafka-to-ClickHouse method is right for your stack?

Written by

Armend Avdijaj

ClickHouse Learnings

Challenges of Connecting Flink to ClickHouse

Why integrating Flink with ClickHouse is difficult – key challenges explained

Written by

Armend Avdijaj

ClickHouse Learnings

Challenges of Connecting Flink to ClickHouse

Why integrating Flink with ClickHouse is difficult – key challenges explained

Written by

Armend Avdijaj

ClickHouse Learnings

Limitations of Flink to ClickHouse Integration – What You Need to Know

Flink + ClickHouse: Integration challenges explained.

Written by

Armend Avdijaj

ClickHouse Learnings

Limitations of Flink to ClickHouse Integration – What You Need to Know

Flink + ClickHouse: Integration challenges explained.

Written by

Armend Avdijaj

Comparisons

Flink Alternatives for ClickHouse: Real-Time Streaming Without the Overhead

Compares Flink alternatives for real-time ClickHouse integration.

Written by

Armend Avdijaj

Comparisons

Flink Alternatives for ClickHouse: Real-Time Streaming Without the Overhead

Compares Flink alternatives for real-time ClickHouse integration.

Written by

Armend Avdijaj

ClickHouse Learnings

Why Companies Build Custom Go Ingestion Services for ClickHouse

Why companies build custom Go ingestion services for ClickHouse pipelines.

Written by

Armend Avdijaj

ClickHouse Learnings

Why Companies Build Custom Go Ingestion Services for ClickHouse

Why companies build custom Go ingestion services for ClickHouse pipelines.

Written by

Armend Avdijaj

ClickHouse Learnings

Bitcoin to ClickHouse

Stream Bitcoin to ClickHouse in real time-without duplicate records

Written by

Guest Author: Karolis Ščerbiakas

ClickHouse Learnings

Bitcoin to ClickHouse

Stream Bitcoin to ClickHouse in real time-without duplicate records

Written by

Guest Author: Karolis Ščerbiakas

Tutorials

GlassFlow: ClickHouse Duplications and JOINs solved for Kafka Users

Learn how we will solve the biggest challenges of Kafka users with ClickHouse.

Written by

Armend Avdijaj

Tutorials

GlassFlow: ClickHouse Duplications and JOINs solved for Kafka Users

Learn how we will solve the biggest challenges of Kafka users with ClickHouse.

Written by

Armend Avdijaj

ClickHouse Learnings

Part 1: How do you usually ingest data from Kafka to ClickHouse?

Deep dive on raw data ingestions from Kafka to ClickHouse.

Written by

Armend Avdijaj

ClickHouse Learnings

Part 1: How do you usually ingest data from Kafka to ClickHouse?

Deep dive on raw data ingestions from Kafka to ClickHouse.

Written by

Armend Avdijaj

ClickHouse Learnings

Part 2: Why are duplicates happening and JOINs slowing ClickHous

Learn the root of the duplication and JOINs issues of Kafka to ClickHouse.

Written by

Armend Avdijaj

ClickHouse Learnings

Part 2: Why are duplicates happening and JOINs slowing ClickHous

Learn the root of the duplication and JOINs issues of Kafka to ClickHouse.

Written by

Armend Avdijaj

ClickHouse Learnings

Part 3: ClickHouse ReplacingMergeTree and Materialized Views are not enough

Deep dive on limitations of ReplacingMergeTree and Materialized Views.

Written by

Armend Avdijaj

ClickHouse Learnings

Part 3: ClickHouse ReplacingMergeTree and Materialized Views are not enough

Deep dive on limitations of ReplacingMergeTree and Materialized Views.

Written by

Armend Avdijaj

ClickHouse Learnings

Part 4: Can Apache Flink be the solution?

Apache Flink isn't the solution for duplications and JOINs on ClickHouse.

Written by

Armend Avdijaj

ClickHouse Learnings

Part 4: Can Apache Flink be the solution?

Apache Flink isn't the solution for duplications and JOINs on ClickHouse.

Written by

Armend Avdijaj

ClickHouse Learnings

Part 5: How GlassFlow will solve Duplications and JOINs for ClickHouse

Learn the details on how GlassFlow will solve Duplications and JOINs.

Written by

Armend Avdijaj

ClickHouse Learnings

Part 5: How GlassFlow will solve Duplications and JOINs for ClickHouse

Learn the details on how GlassFlow will solve Duplications and JOINs.

Written by

Armend Avdijaj

ClickHouse Learnings

ClickHouse Glossary

ClickHouse Glossary: Key terms for engines, joins & real-time data

Written by

Meryem Cebeci

ClickHouse Learnings

ClickHouse Glossary

ClickHouse Glossary: Key terms for engines, joins & real-time data

Written by

Meryem Cebeci

Announcements

Announcing our $4.8m seed round

GlassFlow has successfully raised its seed round. Learn more about our journey.

Written by

Armend Avdijaj

Announcements

Announcing our $4.8m seed round

GlassFlow has successfully raised its seed round. Learn more about our journey.

Written by

Armend Avdijaj

Cleaned Kafka Streams for ClickHouse

Clean Data. No maintenance. Less load for ClickHouse.

Start building

Cleaned Kafka Streams for ClickHouse

Clean Data. No maintenance. Less load for ClickHouse.

Start building

2025 – Copyright

2025 – Copyright