Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

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 @