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

£54.99

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

Name: Unlocking dbt: Design and Deploy Transformations in Your Cloud Data Warehouse
Brand: Apress
Price: 54.99 GBP
Availability: InStock

Database Management Systems

This is the most expensive it has ever been. Walk away.

£55 today · previous high £55 · all-time low £46

NEW HERE?

Amazon shows you one price. We show you all of them.

Tosheroon watches Amazon prices so you don't have to. Every product on Amazon has a price history — we make it visible. Set the price you'd actually pay, and we'll email you the second it gets there. No app, no account, one email.

WHAT'S ON THIS PAGE

↓ Price chart
when this has been cheap or pricey

↓ Forecast
where the price is heading next

↓ Statistics
all-time high & low, recent range

↑ Price alert
name your number, we'll email you

Price History & Forecast

Grey patches = out of stock. Cheaper = lower on the chart. Hover for exact prices.

Last 48 days · 48 data points (no recent data)

Historical

Generating forecast…

Price Distribution

Price distribution over 48 days • 2 price levels

Days at Price

Current Price

Price Analysis

Most common price: £55 (46 days, 95.8%)

Price range: £46 - £55

Price levels: 2 different prices over 48 days

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

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

Barcode

No barcode data available

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

This is the most expensive it has ever been. Walk away.

Price History & Forecast

Price Distribution

Price Analysis

Description

Product Specifications

Barcode

Similar Products You Might Like

O'Reilly Analytics Engineering with SQL and dbt Book

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

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

Modern Python Cookbook: 130+ updated recipes for modern Python 3.12 with new techniques and tools

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

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

Azure Data Factory by Example: Practical Implementation for Data Engineers

Machine Learning for Business Analytics: Concepts, Techniques, and Applications in Python

Data Engineering Design Patterns: Recipes for Solving the Most Common Data Engineering Problems

Digital Transformation in Business and Society: Theory and Cases

New Trends in Business Information Systems and Technology: Digital Innovation and Digital Business Transformation: 294 (Studies in Systems, Decision and Control, 294)

Data Quality in the Age of AI: Building a foundation for AI strategy and data culture

Pro Power BI Desktop: Self-Service Analytics and Data Visualization for the Power User

Data Virtualization for Business Intelligence Systems: Revolutionizing Data Integration for Data Warehouses (Morgan Kaufmann Series on Business Intelligence)

Apress Essential Data Analytics, Data Science, and AI Guide

Financial Data Engineering: Design and Build Data-Driven Financial Products

AI Data Privacy and Protection: The Complete Guide to Ethical AI, Data Privacy, and Security

Strategic Digital Transformation: A Results-Driven Approach (Business and Digital Transformation)

Elements of Digital Transformation

Modern Data Architecture on Azure: Design Data-centric Solutions on Microsoft Azure

The Practical Guide to Digital Transformation: Quickly Master the Essentials with Tips, Case Studies and Actionable Advice

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

Digital Transformation of Industry: Continuing Change (Decision Engineering)

Advances in Internet, Data and Web Technologies: The 8th International Conference on Emerging Internet, Data and Web Technologies (EIDWT-2020): 47 ... and Communications Technologies, 47)