How to set up ClickHouse for agentic analytics

DWAINE, an internal AI agent at ClickHouse, exemplifies how AI is reshaping business analytics by providing direct answers to stakeholders' queries, bypassing traditional dashboards. However, such AI systems can sometimes make errors due to inadequate context or suboptimal warehouse designs. The evolving landscape of data warehousing emphasizes the importance of isolating workloads by compute resources and exposing only curated data marts to AI to ensure accuracy and prevent misinformation. ClickHouse Cloud's architecture supports this by separating storage from compute, allowing dedicated resources for specific workloads without data duplication. The setup includes creating multiple services, such as ingestion and transformation services, and establishing access controls to implement guardrails. The transformation process involves organizing data into raw, staging, and marts layers, with a focus on canonical metrics and low latency. The article underscores the need for warehouses to meet the demands of conversational analytics while maintaining core principles to ensure reliable and accurate AI-powered insights.