Price loading...

Unlocking dbt: Design and Deploy Transformations in Your Cloud Data Warehouse

Data Warehousing

Price data last checked 108 day(s) ago - refreshing...

View at Amazon

Price History & Forecast

No Price Data Available

Price history will appear here once data is collected from Amazon.

Price Distribution

No price data available for histogram

Description

This book shows how dbt is used to build data transformation pipelines that enable dependency management and allow for version control and automated testing. It explains how dbt is revolutionizing data transformation and the advantages that a command-line tool like dbt provides over and above the use of database stored procedures and other ETL and ELT tools that handle data transformations. You’ll see how to create custom-written transformations through simple SQL SELECT statements, eliminating the need for boilerplate code and making it easy to incorporate dbt as the transformation layer in your data warehouse pipelines. Additionally, you will learn how dbt enables data teams to incorporate software engineering best practices such as code reusability, version control, and automated testing into the data transformation process. Unlocking dbt walks you through using dbt to establish a project, build and modularize SQL models, and execute jobs in away that is easy to maintain and scale as your data ecosystem matures. You’ll begin by establishing and configuring a project, a process covered using both dbt Cloud and dbt Core, so that you can confidently stand up a project using either platform. From there, you’ll move into building transformations with peace of mind that your project will scale appropriately as you continue to develop it. After learning the basics needed to get started, you’ll continue to build on that foundation by looking at the unique ways in which dbt combines SQL with Jinja to take your code beyond what is capable in normal SQL. You will learn about advanced materializations, building lineage in your data flows, the unlimited potential of macros, and so much more. This book also explores supported file types and the building of Python models. Rounding things out, you will learn features of dbt that will assist you in making your transformation layer production ready. These includehow to implement automated testing, using dbt to generate documentation, and running CI/CD pipelines. What You Will Learn Understand what dbt is and how it is used in the modern data stack Set up a project using both dbt Cloud and dbt Core Connect a dbt project to a cloud data warehouse Build SQL and Python models that are scalable and maintainable Configure development, testing, and production environments Capture reusable logic in the form of Jinja macros Incorporate version control with your data transformation code 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.

Product Specifications

Format: paperback
ASIN: 1484296990
Category: Books > Subjects > Computing & Internet > Databases > Data Storage & Management > Data Warehousing
Domain: Amazon UK
Release Date: 26 September 2023
Listed Since: 28 June 2023

Barcode

No barcode data available

Unlocking dbt: Design and Deploy Transformations in Your Cloud Data Warehouse

Price History & Forecast

No Price Data Available

Price Distribution

Description

Product Specifications

Barcode

Similar Products You Might Like

Data Engineering with Advanced Python: Learn to Build Production Data applications using Modern Cloud Data tools (Data Engineering with Python cookbook series)

Building the Snowflake Data Cloud: Monetizing and Democratizing Your Data

The Modern Data Warehouse in Azure: Building with Speed and Agility on Microsoft’s Cloud Platform

O'Reilly Analytics Engineering with SQL and dbt Book

Modern Data Engineering with Apache Spark: A Hands-On Guide for Building Mission-Critical Streaming Applications

Mapping Data Flows in Azure Data Factory: Building Scalable ETL Projects in the Microsoft Cloud

Amazon Redshift Cookbook: Recipes for building modern data warehousing solutions

Azure Data Factory Cookbook: Build ETL, Hybrid ETL, and ELT pipelines using ADF, Synapse Analytics, Fabric and Databricks

Beginning Microsoft Dataverse: Exploiting Microsoft’s Low-code Database for the Power Platform

The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform

The Data Science Manual: A Comprehensive Guide to Tools and Techniques for Data Analysis, Modeling, and Deployment with Python

The Data Vault Guru: a pragmatic guide on building a data vault

Data Modeling with Snowflake: A practical guide to accelerating Snowflake development using universal data modeling techniques

Maturing the Snowflake Data Cloud: A Templated Approach to Delivering and Governing Snowflake in Large Enterprises

Mastering Snowflake Solutions: Supporting Analytics and Data Sharing

The Azure Data Lakehouse Toolkit: Building and Scaling Data Lakehouses on Azure with Delta Lake, Apache Spark, Databricks, Synapse Analytics, and Snowflake

Data Modeling with Snowflake: A practical guide to accelerating Snowflake development using universal modeling techniques

Getting Started with DuckDB: A practical guide for accelerating your data science, data analytics, and data engineering workflows

Big Data Science & Analytics: A Hands-On Approach

Demystifying Digital Transformation: Non-Technical Toolsets for Business Professionals Thriving in the Digital Age

Java Microservices and Containers in the Cloud: With Spring Boot, Kafka, PostgreSQL, Kubernetes, Helm, Terraform and AWS EKS

SQL Server 2017 Integration Services Cookbook: Powerful ETL techniques to load and transform data from almost any source

Alteryx Designer Cookbook: Over 60 recipes to transform your data into insights and take your productivity to a new level

Advanced Platform Development with Kubernetes: Enabling Data Management, the Internet of Things, Blockchain, and Machine Learning