# Que devient dbt quand l’IA écrit le code ? (and news) - Show Notes

# Show Notes: Que devient dbt quand l'IA écrit le code ? (and news)

## Episode Summary

In this two-part episode, we explore how AI is transforming analytics engineering with Benoît Périgaud from dbt Labs, who shares insights on AI-powered code generation, the future of dbt, and whether traditional data skills will remain relevant. The second half covers the latest AI and data industry news, including Anthropic's Mythos release, managed agents, and the convergence of agent architectures.

## Key Topics Discussed

### Part 1: AI & dbt with Benoît Périgaud

- **AI integration at dbt Labs**: Skills engine, MCP server, and dbt Index for agent optimization

- **Token efficiency challenges**: Managing context windows for large dbt projects (1000+ models)

- **The future of analytics engineering**: Will agents replace the need to learn dbt?

- **Framework advantages**: Why agents prefer using frameworks like dbt over writing raw SQL

- **Benchmarking AI performance**: The 8Bench Analytics Engineering Benchmark and its limitations

- **Business context problem**: The missing piece in agent-generated analytics code

### Part 2: Industry News

- **Anthropic's Mythos model**: $25/million tokens, 5x price increase, cybersecurity focus, and controversy

- **Managed Agents**: Anthropic's new architecture for hosting agents with virtualized components

- **MCP vs CLI debate**: Token optimization strategies and implementation best practices

- **Cloudflare's approach**: Search and Execute tools instead of 2,600 API endpoints

- **Sandbox evolution**: The concept of user-specific runtimes embedded in applications

- **DuckLake V1 release** and other data ecosystem updates

## Notable Quotes

> "Most frontend models know how to write dbt... But what they know less is the process—how to think about creating a model." - Benoît Périgaud

> "Ruby on Rails is doing a revival because agents are really good at using frameworks... it uses a lot less tokens than doing it from scratch." - Benoît on why dbt will remain relevant

> "The intelligence wasn't scaffolding a fresh app—it was understanding an environment that is already stateful and using code as a mechanism to interact with it." - Discussing Cloudflare's sandbox philosophy

## Resources & Links Mentioned

- **dbt Tools**: dbt Skills, MCP Server, dbt Index (upcoming)

- **Benchmarks**: [8Bench](https://8bench.com) - Analytics Engineering Benchmark

- **Cloudflare Talk**: Sunil Pai's presentation at AI Engineer Europe on MCP optimization

- **Anthropic releases**: Mythos model, Advisor tool, Managed Agents, auto-approval mode

- **Google Gemma 2**: New open-weight multimodal model for edge devices

- **DuckLake V1**: Stable release with in-memory caching

- **State of Analytics Engineering**: Annual report from dbt Labs (released during recording)

## Guest Bio

**Benoît Périgaud** works on the Developer Experience team at dbt Labs, where he's spent four years building AI integrations for the platform. His recent projects include the dbt Skills engine, MCP server implementation, semantic layer benchmarks, and the upcoming dbt Index feature designed to optimize agent interactions with large dbt projects.

---

*Episode features two segments: AI/dbt discussion (beginning) and industry news roundup (second half). Use chapter markers to skip to your preferred section.*