{"product_id":"unlocking-dbt-design-and-deploy-transformations-in-your-cloud-data-warehouse-9798868818431","title":"Unlocking Dbt: Design and Deploy Transformations in Your Cloud Data Warehouse","description":"\u003cp\u003e\u003cstrong\u003eMaster the art of data transformation with the second edition of this trusted guide to dbt.\u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003eBuilding 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.\u003c\/p\u003e \u003cp\u003eUnlocking 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.\u003c\/p\u003e \u003cp\u003eAs 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.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eWhat You Will Learn\u003c\/strong\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eUnderstand dbt and its role in the modern data stack\u003c\/li\u003e \u003cli\u003eSet up projects using both the cloud-hosted dbt Platform and open source project\u003c\/li\u003e \u003cli\u003eConnect dbt projects to cloud data warehouses\u003c\/li\u003e \u003cli\u003eBuild scalable models in SQL and Python\u003c\/li\u003e \u003cli\u003eConfigure development, testing, and production environments\u003c\/li\u003e \u003cli\u003eCapture reusable logic with Jinja macros\u003c\/li\u003e \u003cli\u003eIncorporate version control with your data transformation code\u003c\/li\u003e \u003cli\u003eSeamlessly connect your projects using dbt Mesh\u003c\/li\u003e \u003cli\u003eBuild and manage a semantic layer using dbt\u003c\/li\u003e \u003cli\u003eDeploy dbt using CI\/CD best practices\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cstrong\u003eWho This Book Is For\u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003eCurrent 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.\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cstrong\u003eDustin Dorsey\u003c\/strong\u003e 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.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eCameron Cyr\u003c\/strong\u003e 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.\u003c\/p\u003e\u003cbr\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":51834652066066,"sku":"9798868818431","price":32.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_862d5c5c-4df2-463c-a081-c29029fbeb68.jpg?v=1767097551","url":"https:\/\/surprise-castle.myshopify.com\/products\/unlocking-dbt-design-and-deploy-transformations-in-your-cloud-data-warehouse-9798868818431","provider":"Surprise Castle","version":"1.0","type":"link"}