Unlocking Dbt: Design and Deploy Transformations in Your Cloud Data Warehouse
暫譯: 解鎖 Dbt：在雲端資料倉儲中設計與部署轉換

Dorsey, Dustin, Cyr, Cameron

Unlocking Dbt: Design and Deploy Transformations in Your Cloud Data Warehouse
  • 出版商: Apress
  • 出版日期: 2025-10-02
  • 售價: $1,830
  • 貴賓價: 9.5 折 $1,739
  • 語言: 英文
  • 頁數: 474
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 9798868818431
  • ISBN-13: 9798868818431
  • 相關分類: Data-visualization

    • 海外代購書籍(需單獨結帳)

商品描述

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.

商品描述(中文翻譯)

掌握數據轉換的藝術，透過這本值得信賴的指南《Unlocking dbt, Second Edition》的第二版。 本書在第一版的基礎上進行擴展，提供了對 dbt 功能更深入、更全面的探索——無論您是這個工具的新手，還是希望提升技能的使用者。它深入探討了最新的功能和技術，為您提供創建可擴展、可維護且準備投入生產的數據轉換管道所需的工具。

Unlocking dbt, Second Edition 介紹了關鍵的進展，包括語義層，這使您能夠在大規模上定義和管理指標，以及 dbt Mesh，讓組織能夠自信地協調去中心化的數據工作流程。您還將探索更先進的測試能力、擴展的 CI/CD 和部署策略，以及文檔的增強——例如新引入的 dbt Catalog。

與第一版一樣，您將學習如何利用 dbt 的力量將原始數據轉換為可行的見解，同時融入軟體工程的最佳實踐，如代碼重用、版本控制和自動化測試。從使用 dbt Platform 或開源 dbt 配置項目，到使用 SQL 和 Jinja 精通高級轉換，本書提供了您有效應對現實世界挑戰所需的一切。

您將學到什麼


  • 了解 dbt 及其在現代數據堆疊中的角色

  • 使用雲端托管的 dbt Platform 和開源項目設置項目

  • 將 dbt 項目連接到雲數據倉庫

  • 在 SQL 和 Python 中構建可擴展的模型

  • 配置開發、測試和生產環境

  • 使用 Jinja 宏捕捉可重用邏輯

  • 將版本控制納入您的數據轉換代碼

  • 使用 dbt Mesh 無縫連接您的項目

  • 使用 dbt 構建和管理語義層

  • 使用 CI/CD 最佳實踐部署 dbt

本書適合誰閱讀


目前和有志於成為數據專業人士的人士，包括架構師、開發人員、分析師、工程師、數據科學家和顧問，他們正在開始將 dbt 作為其數據管道轉換層的一部分。讀者應具備撰寫基本 SQL 語句、開發最佳實踐以及在數據倉庫等分析上下文中處理數據的基礎知識。

作者簡介

Dustin Dorsey is a data leader and architect who has been building and managing data solutions for more than 16 years. He is currently a leader in the data consulting space and works with companies of all sizes to modernize and scale their data analytics environments. A respected voice in the data community, Dustin is an international speaker and mentor. He has also organized several data community events and user groups in his local community of Nashville, Tennessee. Dustin is a co-author of the popular Apress books Pro Database Migration to Azure and Unlocking dbt.

Cameron Cyr is a data fanatic who has spent his career developing data systems that enable valuable use cases such as analytics and machine learning. He specializes in building reliable, scalable architectures with a strong emphasis on data quality. As a data consultant, Cameron provides engineering, architecture, and analytics services. He is also a co-author of Unlocking dbt.

作者簡介(中文翻譯)

Dustin Dorsey 是一位數據領導者和架構師，擁有超過 16 年的數據解決方案建設和管理經驗。他目前在數據諮詢領域擔任領導者，與各種規模的公司合作，現代化並擴展他們的數據分析環境。作為數據社群中受人尊敬的聲音，Dustin 是國際演講者和導師。他還在他位於田納西州納什維爾的當地社區組織了幾個數據社群活動和用戶小組。Dustin 是 Apress 出版的熱門書籍 Pro Database Migration to Azure 和 Unlocking dbt 的共同作者。

Cameron Cyr 是一位數據狂熱者，他的職業生涯致力於開發能夠實現有價值用例（如分析和機器學習）的數據系統。他專注於構建可靠、可擴展的架構，並強調數據質量。作為數據顧問，Cameron 提供工程、架構和分析服務。他也是 Unlocking dbt 的共同作者。

類似商品