Unlocking dbt
Design and Deploy Transformations in Your Cloud Data Warehouse
- English
- ePUB (mobile friendly)
- Available on iOS & Android
Unlocking dbt
Design and Deploy Transformations in Your Cloud Data Warehouse
About this book
Master the art of data transformation with the second edition of this trusted guide to dbt.
Building on the foundation of the first edition, this updated volume offers a deeper, more comprehensive exploration of dbt’s capabilities—whether you're new to the tool or looking to sharpen your skills. It dives into the latest features and techniques, equipping you with the tools to create scalable, maintainable, and production-ready data transformation pipelines.
Unlocking dbt, Second Edition introduces key advancements, including the semantic layer, which allows you to define and manage metrics at scale, and dbt Mesh, empowering organizations to orchestrate decentralized data workflows with confidence. You’ll also explore more advanced testing capabilities, expanded CI/CD and deployment strategies, and enhancements in documentation—such as the newly introduced dbt Catalog.
As in the first edition, you’ll learn how to harness dbt’s power to transform raw data into actionable insights, while incorporating software engineering best practices like code reusability, version control, and automated testing. From configuring projects with the dbt Platform or open source dbt to mastering advanced transformations using SQL and Jinja, this book provides everything you need to tackle real-world challenges effectively.
What You Will Learn
- Understand dbt and its role in the modern data stack
- Set up projects using both the cloud-hosted dbt Platform and open source project
- Connect dbt projects to cloud data warehouses
- Build scalable models in SQL and Python
- Configure development, testing, and production environments
- Capture reusable logic with Jinja macros
- Incorporate version control with your data transformation code
- Seamlessly connect your projects using dbt Mesh
- Build and manage a semantic layer using dbt
- Deploy dbt using CI/CD best practices
Who This Book Is For
Current and aspiring data professionals, including architects, developers, analysts, engineers, data scientists, and consultants who are beginning the journey of using dbt as part of their data pipeline’s transformation layer. Readers should have a foundational knowledge of writing basic SQL statements, development best practices, and working with data in an analytical context such as a data warehouse.
Tools to learn more effectively
Saving Books
Keyword Search
Annotating Text
Listen to it instead
Information
Table of contents
- Unlocking dbt
- Preface
- Acknowledgments
- Table of Contents
- About the Authors
- About the Technical Reviewer
- 1. Introduction to dbt
- 2. Data Modeling
- 3. Setting Up a dbt Project
- 4. Sources and Seeds
- 5. Models
- 6. Snapshots
- 7. Jinja, Macros, and Packages
- 8. Hooks
- 9. Tests
- 10. Documentation
- 11. dbt in Production
- 12. dbt Mesh
- 13. Semantic Layer
- Index
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app