# How Critical Manufacturing uses ClickHouse to bring real-time intelligence to the factory floor

DevFeed: [How Critical Manufacturing uses ClickHouse to bring real-time intelligence to the factory floor](<https://devfeed.tech/articles/how-critical-manufacturing-uses-clickhouse-to-bring-real-time-intelligence-to-the-factory-floor-5219.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/criticial-manufacturing>)

Author: ClickHouse

Published: 2026-03-10T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [Kafka](<https://devfeed.tech/topics/kafka.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [Streaming](<https://devfeed.tech/topics/streaming.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [observability](<https://devfeed.tech/topics/observability.md>), [systems](<https://devfeed.tech/topics/systems.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data](<https://devfeed.tech/tags/data.md>), [kafka](<https://devfeed.tech/tags/kafka.md>), [manufacturing](<https://devfeed.tech/tags/manufacturing.md>), [observability](<https://devfeed.tech/tags/observability.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [telemetry](<https://devfeed.tech/tags/telemetry.md>)

## AI overview

Critical Manufacturing uses ClickHouse Cloud to turn billions of shop-floor events into sub-second analytics and operational intelligence. The article describes Kafka-based ingestion, real-time dashboards, scalable data storage, observability, and AI workloads, along with migration from SQL Server and techniques including ELT, ReplacingMergeTree, denormalization, and TTL.

## Source excerpt

"ClickHouse was the perfect fit for what we were doing. It just worked." Ricardo Magalhaes, Lead Software Engineer