# How SewerAI is using ClickHouse to modernize sewer management at scale

DevFeed: [How SewerAI is using ClickHouse to modernize sewer management at scale](<https://devfeed.tech/articles/how-sewerai-is-using-clickhouse-to-modernize-sewer-management-at-scale-5565.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/sewerai-sewer-management-at-scale>)

Author: ClickHouse

Published: 2025-09-19T00:00:00Z

Content type: article

Language: en

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

Topics: [data](<https://devfeed.tech/topics/data.md>), [dataset](<https://devfeed.tech/topics/dataset.md>), [object-detection](<https://devfeed.tech/topics/object-detection.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [computer-vision](<https://devfeed.tech/tags/computer-vision.md>), [data](<https://devfeed.tech/tags/data.md>), [real-time](<https://devfeed.tech/tags/real-time.md>)

## AI overview

SewerAI uses ClickHouse for real-time analytics on large volumes of sewer-inspection data and describes denormalizing its dataset into a single Megatable to keep analytics current and costs controlled.

## Source excerpt

"Our compute usage remained stable. We didn't have any more failing updates. Because of that, we didn't have backlogs. Our analytics were up to date, and our customers were happy."