Build a production-ready Genie space by curating tables, views and SQL functions and adding instructions, sample questions and trusted SQL
Choose few-shot examples by their marginal value (untested tool paths, output structure, ambiguous inputs) within a token budget
Fix a miscalibrated system prompt with the smallest change, and read MLflow experiment results to judge whether a longer prompt pays off
Diagnose AI Search problems (chunking, embedding context length, metadata gaps) and restrict retrieval to authoritative Unity Catalog assets
Decide between pre-inference retrieval and just-in-time agentic retrieval (tool calls, live Delta queries)
Hands-on: Create a Genie space over two or three sample tables. Run 10 business questions, then add table comments, a trusted SQL query and two instructions. Re-run the questions and record which answers improved.
Match the information need to the right memory type (in-session history, Delta-backed state object or Lakebase long-term store)
Choose AI Search or a structured query for memories persisted in Lakebase
Spot over-retrieval (context pollution) and under-retrieval (missing history), and compare static with dynamic retrieval
Use MLflow 3 runs to compare context configurations across repeated agent runs
Hands-on: Give an agent cross-session memory by writing user preferences to a Lakebase Postgres table and reading them back at the start of a new session. Log both sessions as MLflow traces and compare them.
Use progressive disclosure for MCP tools (staged discovery) instead of loading every tool schema upfront
Find overlapping tool descriptions that cause wrong tool picks, and move rarely used instructions into Agent Skills
Tune a compaction prompt for recall first, then precision, and say which raw tool outputs are safe to clear
Compare aggressive and conservative compaction, and choose between trimming heuristics and model-based compaction
Fix multi-agent failures by passing full traces at dispatch, slimming sub-agent outputs, or moving agent boundaries
Hands-on: Register three Unity Catalog functions as tools, two of them with deliberately overlapping descriptions. Trace which tool the agent picks, rewrite the descriptions until it chooses correctly every time, and record the token difference.