0% completed

All LessonsFree Lessons (4)

Introduction to dbt and Its Setup

Introduction to dbt dbt Core, Cloud, BigQuery: Unveiling Data Transformation Creating a dbt Project Quiz: Introduction to dbt

Overview of the Project Architecture

Folders Structure

Model Configurations

Accessing Compiled Code

Quiz: Project Architecture

Coding Challenge: Complete the project.yml File

Solution: Complete the project.yml File

Models

Creating a SQL Model Referencing Another Model Coding Challenge: Join Two Models Solution: Join Two Models Changing Model Configuration Overriding Default Schema Organizing the Models with Folders and Tags Python Models Quiz: Models

Sources

Setting Up and Referencing a Source Loading CSV Data with Seeds Quiz: Sources Coding Challenge: Querying a Public Dataset Solution: Querying a Public Dataset

Materializations

View Table Incremental Model with the MERGE Strategy Incremental Model with the insert_overwrite Strategy Ephemeral Models Quiz: Materializations Coding Challenge: Daily Incrementation Solution: Daily Incrementation

Dynamic Models with Jinja

Introduction to Jinja Project Variables Environment Variables Setting Up Jinja Variables Iterations Coding Challenge: Loop Through a List of Columns Solution: Loop Through a List of Columns Macros Quiz: Jinja Coding Challenge: Daily Aggregation Macro Solution: Daily Aggregation Macro

Packages

Overview of Packages Downloading a Package from dbt Hub Using Macros from a Package Creating Your First Package Quiz: Packages Coding Challenge: Pack Your Macro Solution: Pack Your Macro

Advanced dbt Concepts

Data Tests Targets Snapshots Hooks Challenge: Store Model Runs Inside a Table Solution: Store Model Runs Inside a Table Analysis Documentation Go Even Further with dbt Quiz: Advanced dbt Concepts Challenge: Targets, Tests, and Documentation Solution: Targets, Tests, and Documentation

Conclusion

Learn Data Build Tools ( DBT )/

...

/

Quiz: Project Architecture

Quiz: Project Architecture

Test your knowledge of dbt project architecture.

We'll cover the following...

Technical Quiz

1.

In which file should we define connection info about our data warehouse, such as the ID of our project and dataset?

A.

dbt_project.yml

B.

profiles.yml

C.

model.sql

D.

target.yml

1 / 4

...