Episode 7. 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

AI Innovation That Delivers: How to Align Strategy, Adoption, and Business Value with Joris Renkens
AI Innovation That Delivers: How to Align Strategy, Adoption, and Business Value with Joris Renkens
AI Innovation That Delivers: How to Align Strategy, Adoption, and Business Value with Joris Renkens

Episode 10. AI Innovation That Delivers: How to Align Strategy, Adoption, and Business Value with Joris Renkens

How can companies truly innovate with AI? Joris Renkens shares practical lessons on strategy, adoption, and building the right teams.

You Don’t Need the Latest Stack. You Need Better Questions. Episode with Rushil Daya & Kris Peeters
You Don’t Need the Latest Stack. You Need Better Questions. Episode with Rushil Daya & Kris Peeters
You Don’t Need the Latest Stack. You Need Better Questions. Episode with Rushil Daya & Kris Peeters

Episode 9. You Don’t Need the Latest Stack. You Need Better Questions. Episode with Rushil Daya & Kris Peeters

Learn to build high-performing data teams with agile practices, strong leadership, CI/CD, testing, mentoring, and collaboration.

 Episode 8. What It Really Takes to Build a Data-Centric Organization, with Jonny Daenen & Kris Peeters
 Episode 8. What It Really Takes to Build a Data-Centric Organization, with Jonny Daenen & Kris Peeters
 Episode 8. What It Really Takes to Build a Data-Centric Organization, with Jonny Daenen & Kris Peeters

Episode 8. What It Really Takes to Build a Data-Centric Organization, with Jonny Daenen & Kris Peeters

What does it take to build truly data-centric organizations?This episode goes beyond tools and dashboards to uncover lasting value.

Leave your email address to subscribe to the Dataminded newsletter

Leave your email address to subscribe to the Dataminded newsletter

Leave your email address to subscribe to the Dataminded newsletter

Belgium

Vismarkt 17, 3000 Leuven - HQ
Borsbeeksebrug 34, 2600 Antwerpen


Vat. BE.0667.976.246

Germany

Spaces Tower One,
Brüsseler Strasse 1-3, Frankfurt 60327, Germany

© 2025 Dataminded. All rights reserved.


Belgium

Vismarkt 17, 3000 Leuven - HQ
Borsbeeksebrug 34, 2600 Antwerpen

Vat. BE.0667.976.246

Germany

Spaces Tower One, Brüsseler Strasse 1-3, Frankfurt 60327, Germany

© 2025 Dataminded. All rights reserved.


Belgium

Vismarkt 17, 3000 Leuven - HQ
Borsbeeksebrug 34, 2600 Antwerpen

Vat. BE.0667.976.246

Germany

Spaces Tower One, Brüsseler Strasse 1-3, Frankfurt 60327, Germany

© 2025 Dataminded. All rights reserved.