赞助方：dbt LabsRiot 数据工程升级：我们如何推出 dbt 并改变开发者体验.pdf

1、RIOT GAMESLeveling UpData Engineeringat Riot GamesHow We Rolled Out dbt and Transformedthe Developer Experience for DataRIOT GAMESRIOT GAMESRiot Games was founded in 2006 with a mission to be the most player-focused game company in the world.We launched League of Legends in 2009 and have since expan

2、ded into titles like TeamfightTactics,Wild Rift,VALORANT,Legends of Runeterra,and our upcoming fighting game 2XKO.We use data to better understand our playersso we can deliver the best possible experiences,both in and out of game.WHO WE AREOne Mission,One Brand,One Riot RIOT GAMES5k+Active Tasks in

3、Production230+Active DAGs in Production7k+CommitsRiots Legacy Software Development Lifecycle(SDLC)RIOT GAMES130+Contributors2021 SDLC EstablishedBefore dbt our data workflows made shipping data harder than it needed to be:Bespoke Pipelines:Custom code with littlereuse or standardization Hard to Test

4、,Easy to Break:Writing automatedtests is difficult High Barrier to Entry:Analysts and new engineers couldnt easily contributeRIOT GAMESRIOT GAMESWith dbt,we saw the opportunity to build ascalable,testable,and collaborative foundation for data modelingone that worked for both engineers and analysts.S

5、treamlined Development:SQL-based modeling and a Cloud IDE lowers the barrier to entry.Collaboration:A common standardized workflowthat makes it easier for analysts and engineers to work together.Built-In Testing:Simple schema and data tests help catch issues early and improve model reliability.dbtto

6、 the RescueRIOT GAMESRIOT GAMES2XKORiots upcoming fighting gamewas the first game team to adopt dbt,standing up a Production data warehouse in record time and setting a new standard for data engineering at Riot.Fast Warehouse Stand-Up:Built and deployed a full analytics stack rapidly 150+dbt Models