Introduction to dbt
In this course we will learn about dbt, the open source tool that is used for data transformations in relational data warehouses. Though dbt is more commonly found against traditional data warehouses, it still potentially serves a useful purpose as part of your ClickHouse deployment.
Introduction To dbt
In this lesson we will introduce dbt and the value it brings to data teams.
Introduction To Testing With dbt
In this lesson we will introduce the various ways in which dbt supports testing as part of a data pipeline.
Benefits Of dbt
In this lesson we will explain the benefits of dbt and the problems with the existing approach;
Defining Tests As Properties
In this lesson we will show how to define static tests as dbt properties.
Using The dbt Command Line Interface
In this lesson we will use the dbt Command Line Interface to create and configure our first dbt project.
Creating A dbt Project
In this lesson we will use the dbt Command Line Interface to create and configure our first dbt project.
Configuring dbt Profiles
In this lesson we will explain the dbt profile system and best practices for managing profiles for maintainable code.
Executing Your First Transformations
In this lesson we will create and run our first transformations using dbt models that build both tables and views.
Linting Your dbt Code
In this lesson we will introduce the concept linting and learn how it can be used to improve the quality of your dbt code.
Materialisation Options and Considerations
In this lesosn we will describe the options and considerations when materialising models in dbt.
Materialising As Views and Tables
In this lesson we will use dbt to materialise to tables and views, and the associated incremental and ephemeral options.
Seed Data
In this lesson we will use dbts seed data feature to reliably populate our database with static data for use as part of dbt transformations.
Testing With dbt
In this lesson we will use the testing features of dbt to validate data transformations and pipelines.
Incremental Views
In this lesson we will learn about dbts incremental updates and incremental views.
Ethemeral Views
In this lesson we will learn about dbts ethemeral view feature to improve your pipeline readability.
Sources and Exposures
In this lesson we will learn about dbts source and exposure features to capture better metadata regarding your pipelines.
Documenting Your Models
In this lesson we will learn about dbts features for automatically generating documentation.
dbt and DevOps
In this lesson we will explain how dbt helps Data Engineers work like software engineers.