Let’s be honest…
Who broke production with
“just a small”
code change at least once?
Slide 3
Slide 3 text
No content
Slide 4
Slide 4 text
Revolutionizing SQL Data
Model Testing
Introducing SQL-Mock by DeepL
Data Geeks Meetup 2023-10-26 - Thomas Schmidt
Slide 5
Slide 5 text
Model stream, ways to test and potential issues
Slide 6
Slide 6 text
Model stream, ways to test and potential issues
Slide 7
Slide 7 text
Model stream, ways to test and potential issues
Slide 8
Slide 8 text
Model stream, ways to test and potential issues
Slide 9
Slide 9 text
We need to replace
references to production models
with static data
Michelle Ark (Shopify)
Slide 10
Slide 10 text
No content
Slide 11
Slide 11 text
No content
Slide 12
Slide 12 text
No content
Slide 13
Slide 13 text
Adjustable
Static Data
Slide 14
Slide 14 text
⛳ SQL Mock Design Goals
● Runs in Python
● Tool agnostic
● Writing unit tests is easy and effortless
● Low verbosity and avoid redundant code
Slide 15
Slide 15 text
Demo Time! 🔥
Munich’s next Top Data Geek
Slide 16
Slide 16 text
👏 Where sql-mock helped us
✅ Test the query syntax
✅ Test that query logic results in intended outcome
✅ Test edge cases
Slide 17
Slide 17 text
🔮 Future plans
● Dbt integration
● Support equality assertion for CTEs within the query
● Generative AI for drafting tests
Slide 18
Slide 18 text
🚀 How to get started?
● pip install “sql-mock[bigquery]”
and start testing
● Check out the repository and add your
ideas / start contributing
Slide 19
Slide 19 text
Ask me now or contact me later if you have questions
Thomas Schmidt
Senior Data Scientist
@DeepL
[email protected]
@somtom91
thomas-heinz-schmidt
We are hiring
@