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

Profiles 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

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: Materializations

Quiz: Materializations

Test your knowledge of materializations in dbt.

We'll cover the following...

Technical Quiz

1.

(Select all that apply.) Which materializations store the data?

A.

Views

B.

Tables

C.

Incremental models

D.

Ephemeral models

1 / 5