Explicit Measures Podcast 453: Creature Comforts of Data Warehouse
Aug 26, 2025
Brad Schacht, a key member of Microsoft's Data Warehouse team, shares insights on enhancing user experience with Microsoft Fabric's data warehouse. The conversation highlights recent innovations like a migration assistant for data mart transitions and user-friendly features to tackle cloud complexities. They discuss improving efficiency in data management, vital for both novice and expert developers. With a focus on custom semantic models and the importance of user profiles, Brad emphasizes how user-driven feedback is shaping the future of data warehousing.
AI Snips
Chapters
Transcript
Episode notes
Item-Level Capacity Visibility
- Microsoft standardized consumption metrics so item-level CU tracking now gives consistent visibility across artifacts.
- This helps identify cost spikes and inefficient items like poorly performing dataflows or notebooks.
Use Lightweight VS Code Profiles
- Use the web-based VS Code and streamlined profiles to develop user data functions without heavy local extensions.
- Keep a minimal VS Code profile for quick edits to avoid slow startup and extension conflicts.
Balancing Citizen And Pro Dev Needs
- The team balanced no-knobs simplicity for citizen devs with adding pro-level SQL features for developers.
- They aim to offer both approachable UX and code-first capabilities, though the perfect balance is evolving.