#300: Are Semantic Layers Really Necessary?

If you've ever poured months into building a semantic layer only to watch it become shelfware the moment the business pivoted, Jacob Matson has some thoughts. And a metaphor. Your data is a jungle—and a semantic layer is a highway. Great if you need to get somewhere fast and reliably (monthly active users: highway, please). But the interesting business questions? The slicing, the dicing, the nuanced dimensions that actually differentiate your company from its competitors? There's no highway for that. There never will be. Jacob, a developer advocate at MotherDuck with deep roots in accounting and ERP systems, joined Michael, Moe, and Julie to talk through what comes after the semantic layer—or at least alongside it. The conversation covered why the most important parts of any business are precisely the parts that resist being modeled in someone else's framework, why AI is actually pretty good at writing SQL but not so great at remembering what it figured out yesterday, and whether the real job to be done here is less about modeling and more about search. Oh, and the uncomfortable truth that at episode 300, we still don't have a great answer for metric drift. But we've got some really good questions. This episode is brought to you, in part, by our sponsors, Stape and Prism from Ask-Y. For complete show notes, including links to items mentioned in this episode and a transcript of the show, visit the show page.