BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//pretalx.com//pyconde-pydata-2024//speaker//PMZLKB
BEGIN:VTIMEZONE
TZID:CET
BEGIN:STANDARD
DTSTART:20001029T040000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
TZNAME:CET
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20000326T030000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
TZNAME:CEST
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:pretalx-pyconde-pydata-2024-EMZ7L7@pretalx.com
DTSTART;TZID=CET:20240423T103000
DTEND;TZID=CET:20240423T110000
DESCRIPTION:As the landscape of data-driven applications expands\, the need
  for robust SQL development practices becomes increasingly critical. This 
 conference talk addresses the challenges faced by data teams in maintainin
 g and evolving complex SQL models for their Data Warehouses\, and shows ho
 w unit testing can play a vital role in ensuring data quality.\n\nWe will 
 delve into the significance of SQL unit testing\, highlighting its ability
  to quickly validate modeling logic and making sure that modifications do 
 not break existing behavior. With the ease of mind of an automatically ver
 ified SQL logic\, changes to existing data models can be shipped with conf
 idence\, ultimately contributing to faster deployment cycles.\n\nGet detai
 led insights on  the structure and functionality of Lotum’s SQL unit tes
 ting framework\, built in Python using pytest and tailored for BigQuery. W
 ith Lotum processing millions of events from mobile games every day\, expl
 ore how this robust framework allows for efficient testing\, ensuring the 
 accuracy of the SQL logic. Learn how test cases with small sets of static 
 mock data can be defined effortlessly so that they help pinpoint potential
  code errors easily.
DTSTAMP:20260611T001926Z
LOCATION:B07-B08
SUMMARY:Unleashing Confidence in SQL Development through Unit Testing - Tob
 ias Lampert
URL:https://pretalx.com/pyconde-pydata-2024/talk/EMZ7L7/
END:VEVENT
END:VCALENDAR