From SQLi Hammer to Full-fledged Software Engineer
summary
Describes using dbt (data build tool) to evolve from writing ad-hoc SQL queries to becoming a full software engineer for data projects. Covers practical dbt features and workflows that improve code quality, testing, and maintainability of analytics code.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 3:39What is dbt and how it works
- 17:26Real dbt use case
- 21:59Setup and first steps
- 31:51Variables and macros in dbt
- 37:14Query execution optimization
- 43:10Data transform testing
- 48:12Generating dbt docs
- 50:17Summary and contact
related talks
49mdbt: A Software Engineering Approach To The Analytics Workflow
39mWhat if SQL was back in fashion?
01h 42mFall in Love with Data Transformation: DBT as Your Weapon
23mDelivering Modern Data Stacks With dbt to Operationalise Analytics
55mThe ELT pattern in action with DBT and SQLMesh
28mHow Open Source Enables Innovation A Case Study with dbt and Lightdash
06mDBTB INT Alya Abbot r
39mLeaving ETLs Behind: Moving from a ‘Code Less’ Solution to a ‘Code Full’ Approach