DBT For Data Engineers

Learn Analytics Engineering Using Open Source DBT

In this course we will go from beginner to implementing advanced data pipelines with clean, maintainable models using DBT.

Introduction To DBT

In this lesson we will introduce DBT, explain the value it brings and explain some of the core concepts behind the platform

View
Hands-On Lab

Creating A DBT Project

In this lesson we will begin using the DBT Command Line Interface. We will then create and configure our first DBT project.

View
Hands-On Lab

Configuring DBT Profiles

In this lesson we will learn more about the DBT profile system and best practices for managing profiles for maintainable code.

View
Hands-On Lab

Executing Your First Transformations

In this lesson we will implement and run our first transformations using DBT models that build both tables and views.

View
Hands-On Lab

DBT Views and Tables

In this lesson we will learn how DBT can materialise to tables and views, and the associated incremental and ephemeral options.

View
Hands-On Lab

Seed Data

In this lesson we will learn about DBTs seed data feature, which allows us to reliably populate our database with static data for use as part of DBT transformations.

View

Testing With DBT

In this lesson we will learn about DBT testing features

View
Hands-On Lab

Incremental Views

In this lesson we will learn about DBT incremental updates or incremental views.

View
Hands-On Lab

Ethemeral Views

In this lesson we will learn about DBTs ethemeral view feature.

View
Hands-On Lab

Sources and Exposures

In this lesson we will learn about DBTs source and exposure features.

View

Documenting Your Models

In this lesson we will learn about DBTs documentation feature

View

© 2022 Timeflow Academy.