Table of Contents

Playbooks
• • How dbt Labs’ data team approaches reverse ETL
How a bill becomes a law
• • How dbt Labs manages OKRs
• • Data lessons learned from benchmarking the IDE’s performance
Our favorite SQL functions
• • A star (generator) is born
• • The surrogate key macro
• • DATEADD SQL function
• • UNION ALL & union_relation macro
• • COALESCE SQL function
• • DATEDIFF SQL function
• • DATE_TRUNC SQL Function
• • LOWER SQL function
• • EXTRACT SQL function
Orchestrating my day
• • Erica Louie, Head of Data at dbt Labs
• • Ian Fahey, Analytics Engineer at dbt Labs