You're reading from Data Engineering with dbt A practical guide to building a cloud-based, pragmatic, and dependable data platform with SQL

Product type Paperback

Published in Jun 2023

Publisher Packt

ISBN-13 9781803246284

Length 578 pages

Edition 1st Edition

Languages

SQL

Tools

dbt

Concepts

Data Engineering

Author (1):

Roberto Zagni

View More author details

Table of Contents (21) Chapters

Preface

1. Part 1: The Foundations of Data Engineering

2. Chapter 1: The Basics of SQL to Transform Data FREE CHAPTER

3. Chapter 2: Setting Up Your dbt Cloud Development Environment

4. Chapter 3: Data Modeling for Data Engineering

5. Chapter 4: Analytics Engineering as the New Core of Data Engineering

6. Chapter 5: Transforming Data with dbt

7. Part 2: Agile Data Engineering with dbt

8. Chapter 6: Writing Maintainable Code

9. Chapter 7: Working with Dimensional Data

10. Chapter 8: Delivering Consistency in Your Data

11. Chapter 9: Delivering Reliability in Your Data

12. Chapter 10: Agile Development

13. Chapter 11: Team Collaboration

14. Part 3: Hands-On Best Practices for Simple, Future-Proof Data Platforms

15. Chapter 12: Deployment, Execution, and Documentation Automation

16. Chapter 13: Moving Beyond the Basics

17. Chapter 14: Enhancing Software Quality

18. Chapter 15: Patterns for Frequent Use Cases

19. Index

Why subscribe?

20. Other Books You May Enjoy

Setting up your GitHub account

GitHub is an online service that offers free and paid access to VC based on the git Version Control System (VCS).

In this chapter, we will briefly introduce you to what a VCS is and why we need one, then we will guide you on how to create an account on GitHub, and finally, we will guide you through setting up a repository to hold your first project in dbt.

Introducing Version Control

Modern code development is based on VC, which is the ability to store source code in a central server so that multiple developers can retrieve the code, work on it, and send back a newer version to be stored. VC allows multiple people to collaborate on the same code base.

The main functionality of a VCS is to allow storing all the different versions of code in the order they are produced and going back and forth to a version of any file at any point in time. VC also allows easily identifying the changes between one version and the next.

A key functionality...