Episode Details
Back to EpisodesAI agents querying your warehouse: measure before rebuilding
Description
Fivetran and dbt Labs used dbt Summit to argue that AI agents, not human analysts, are now the main consumer of enterprise data. The position here is that the architectural shift is real but the urgency is a sales pitch, and that re-platforming off a keynote is the expensive mistake.
You come away able to test dbt Labs' claim that 30% of warehouse queries are machine-generated against your own logs, spot the failure mode where agents pass nonsense results downstream with no scar tissue, make the case for a written semantic layer over new tooling, and set a query budget before an agent touches production. References include O'Reilly Radar and MIT Sloan Management Review.
Key takeaways
- Pull last month's query logs and calculate what share came from service accounts rather than named humans to find your real agent load.
- Treat dbt Labs' 30% machine-generated query figure as directional, since the vendor sells the tooling that raises it.
- If agent traffic is small, spend the quarter writing business definitions down instead of changing architecture.
- Build the semantic layer so terms like active customer are defined in writing, because an agent has no memory to fill the gaps.
- Set a spending cap on agent query volume before a pilot touches production data to avoid a five-figure compute surprise.
Chapters
0:00 Agents as the new data consumer
0:44 What changes when a bot queries
1:12 dbt's 30% machine-generated query claim
2:03 Metadata gaps and the semantic layer
3:04 Compute costs and query budgets
3:49 Check service account query share
Go deeper, free lessons
- dbt (data build tool): industrialized SQL transformation
- Active metadata and the data catalog
- The metrics & semantic layer
- Data lineage & metadata management: knowing where your data was born
- Data products: definition, design & lifecycle management
Sources
- AI coding agents need a secrets-safe context boundary
- Fivetran + dbt Labs Announces New Capabilities to Make Enterprise Data Agent-Ready at dbt Summit 2026
- Everything we announced at dbt Summit and why it matters
- We built dbt State to stop rebuilding what hadn't changed
- Celebrating the 2026 dbt partner of the year winners
- Enterprise Analytics Beyond Dashboards: Intelligent Data Orchestration with LLMs
- Spot New Tech Skills Emerging From the Workforce
- Building on AI’s Unfinished Foundation
Full article and transcript: https://www.mba-training.com/blog/agent-ready-data-infrastructure-dbt
MBA Training, mba-training.com