While Fabric introduces advanced AI capabilities like Data Agents, access often requires premium capacities (F64+). This session demonstrates practical techniques for building your own custom AI agents within Fabric using standard capacities (without F64). We focus on leveraging core Fabric components like Notebooks and Pipelines to achieve useful agentic outcomes, such as automating tasks and interacting with Fabric artifacts.

Explore how to effectively combine these tools to create cost-effective, task-specific agents. We will discuss the benefits of this approach, but also highlight potential pitfalls to avoid. Grounded in years of practical experience managing and developing data warehouses, this session focuses on tangible benefits and avoids marketing buzzwords. We will cover understanding the difference between simpler agentic workflows and more developed AI agents, helping you choose the right approach based on real-world scenarios. We will also illustrate specific patterns and discuss potential architectures for extending these techniques to handle more complex automation scenarios within Fabric.

Key Takeaways:
+ Understand how to build simple AI agents and implement agentic workflows using standard Fabric components (Notebooks, Pipelines).
+ Identify scenarios suitable for custom AI agents vs. simpler workflows or standard automation.
+ Recognize potential pitfalls when building custom agents in Fabric (e.g., complexity, error handling, capacity usage).
+ Articulate the benefits of custom agents for specific automation needs within Fabric.
+ Learn techniques for orchestrating tasks across services effectively.
+ Explore patterns for building cost-effective automation solutions within Fabric.
+ Gain insights into integrating custom solutions with existing workflows and alerts.