S1 E7 | A Deep Dive into SQLMesh: Structured Query Validation and Safe Pipeline Testing with Michiel De Muynck
Jun 19, 2025
•
Kris Peeters & Michiel De Muynck - The Data Playbook Podcast
Michiel De Muynck explores SQLMesh: semantic layer, virtual data environments, and unit testing for SQL-based analytics.
In this episode of The Data Playbook, we take a technical look at SQLMesh, a data transformation framework designed to improve the workflow and reliability of SQL-based data pipelines. Hosted by Kris Peeters, the episode features Michiel De Muynck, Senior Data Engineer at Dataminded, who provides a deep dive into SQLMesh’s internal mechanics, including its use of semantic analysis and isolated runtime environments. Michiel outlines how SQLMesh differentiates itself from tools like dbt by incorporating a semantic parser for SQL, enabling structural validation and more precise error diagnostics during pipeline development. He also explains the implementation of virtual data environments, which allow data engineers to stage, test, and version transformations without impacting production datasets, supporting safer iteration and deployment processes.
Listen & Watch on Spotify
Listen on Apple Podcasts
Latest
S2 E2 | Federated Data Governance in Banking: How ABN AMRO Scaled from 300 Data Owners to 15 Data Domains
How ABN AMRO scaled data governance from 300 owners to 15 domains with a federated model that balances control and autonomy.
S2 E1 | Live from the POA Summit: Simon Harrer on Data Contracts, AI, and the Next Phase of Data Mesh
Simon Harrer shares how data contracts, AI, and MCPs redefine data products and governance in the new era of Data Mesh.
S1 E12 | RADAR by publiq: How AI is Reshaping Cultural Discovery, Without Compromising Privacy
How Publiq uses AI and LLMs in RADAR to enrich cultural data and deliver smarter, privacy-first event recommendations.