Warehouse Analyst Agent

Problem

Every question a manager has - why did signups dip last week, which cohort is churning - becomes a ticket for a data team of two. Answers take days, so people stop asking and start guessing.

Solution

An agent that translates a plain-English question into SQL against a governed subset of the warehouse, runs it read-only, and returns the number alongside the query and the row count so the answer can be checked rather than trusted.

Tech stack

Required integrations

• Warehouse (Snowflake, BigQuery, Redshift, Postgres)
• dbt metadata for column descriptions and lineage
• Slack for asking and answering in place

Key features

• Read-only credentials with a hard row and cost ceiling per query
• Generated SQL shown with every answer, always
• Metric definitions as a shared, versioned layer
• Refuses out-of-scope questions instead of approximating
• Query log with who asked what, for audit and for finding the real FAQs