# dltHub on ClickHouse: the ClickHouse Agent walkthrough

DevFeed: [dltHub on ClickHouse: the ClickHouse Agent walkthrough](<https://devfeed.tech/articles/dlthub-on-clickhouse-the-clickhouse-agent-walkthrough-131082.md>)

Original publisher: [Read original article](<https://dlthub.com/blog/clickhouse-agent-ontology-walkthrough>)

Author: Thierry Jean

Published: 2026-11-10T23:00:00Z

Content type: article

Language: en

Sources: [DLT Hub](<https://devfeed.tech/sources/dlt-hub.md>)

Topics: [Agent Harness](<https://devfeed.tech/topics/agent-harness.md>), [etl](<https://devfeed.tech/topics/etl.md>), [semantic-layer](<https://devfeed.tech/topics/semantic-layer.md>), [AI Agent](<https://devfeed.tech/topics/ai-agent.md>), [AI agent hallucinations](<https://devfeed.tech/topics/ai-agent-hallucinations.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [agent-harness](<https://devfeed.tech/tags/agent-harness.md>), [aggregates](<https://devfeed.tech/tags/aggregates.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [ai-harness](<https://devfeed.tech/tags/ai-harness.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [bug](<https://devfeed.tech/tags/bug.md>), [business](<https://devfeed.tech/tags/business.md>), [business-context](<https://devfeed.tech/tags/business-context.md>), [canonical](<https://devfeed.tech/tags/canonical.md>), [ci](<https://devfeed.tech/tags/ci.md>), [claude](<https://devfeed.tech/tags/claude.md>), [claude-code](<https://devfeed.tech/tags/claude-code.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [demo](<https://devfeed.tech/tags/demo.md>), [github](<https://devfeed.tech/tags/github.md>), [ontology](<https://devfeed.tech/tags/ontology.md>), [product](<https://devfeed.tech/tags/product.md>), [updates](<https://devfeed.tech/tags/updates.md>), [waste](<https://devfeed.tech/tags/waste.md>)

## AI overview

The walkthrough shows how dltHub makes ClickHouse Agent answers about GitHub CI waste more consistent by supplying shared business definitions. Without context, the agent invents a definition; dltHub instead stores table and column descriptions in ClickHouse comments and keeps the "CI waste" definition in a versioned ontology alongside pipeline code. The AI Harness helps create and schedule a pipeline, shape data into a canonical model, and deploy tested transformations. The agent can then answer from the defined metric, with results traceable to it and data prepared for follow-up analytics. Loading data with the AI Harness is available today; writing ontology meaning into ClickHouse is in private preview. Comments are updated on pipeline runs, not immediately when a schema changes.

## Source excerpt

Demo walkthrough: dltHub loads GitHub data, its definitions and an ontology into ClickHouse, so ClickHouse Agent answers how much CI is waste.