Episode Details

Back to Episodes

AI agents querying your warehouse: measure before rebuilding

Episode 94 Published 1 month ago
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

Sources

Full article and transcript: https://www.mba-training.com/blog/agent-ready-data-infrastructure-dbt

MBA Training, mba-training.com

Listen Now

Love PodBriefly?

If you like Podbriefly.com, please consider donating to support the ongoing development.

Support Us