Unleashing Confidence in SQL Development through Unit Testing – Tobias Lampert (Lotum)

As data-driven applications grow, robust SQL development practices are crucial. This talk explores the challenges of maintaining complex SQL models in Data Warehouses and highlights the importance of unit testing in ensuring data quality. Attendees will learn how SQL unit testing validates modeling logic, prevents breaking changes, and supports faster deployment cycles. The session features Lotum’s Python-based SQL unit testing framework for BigQuery, which processes millions of daily events from mobile games. Discover how using small, static mock data simplifies testing and helps identify code errors efficiently.

Tobias Lampert is an experienced technical leader with expertise in Data Science and Data Engineering. With over 20 years of experience, he has designed and implemented data-intensive applications end-to-end, covering everything from data ingestion to deployment. He has developed solutions that generate insights from data using statistical analysis and machine learning. His passion lies in building user-friendly, high-performance, and cost-efficient data platforms.

This talk was recorded at PyData Rhein-Main at TU Darmstadt.
https://www.meetup.com/pydata-rhein-main/

🙋 We’re always looking for speakers for future meetups, if you’d like to speak at our meetup: https://bit.ly/talk-at-pydata-rm

Follow us on LinkedIn:
https://www.linkedin.com/company/pydata-rhein-main

❤️ Thanks for helping up to make this meetup possible:

Pioneers Hub
https://pioneershub.org

Hessian.ai
https://hessian.ai/

www.pydata.org

PyData is an educational program of NumFOCUS, a 501(c)3 non-profit organization in the United States. PyData provides a forum for the international community of users and developers of data analysis tools to share ideas and learn from each other. The global PyData network promotes discussion of best practices, new approaches, and emerging technologies for data management, processing, analytics, and visualization. PyData communities approach data science using many languages, including (but not limited to) Python, Julia, and R.