Learn Data Build Tools ( DBT )

0%

1.Introduction to dbt and Its Setup

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

2.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

3.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

4.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

5.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

6.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

7.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

8.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

9.Conclusion

Learn Data Build Tools ( DBT )/

...

/

Solution: Join Two Models

Solution: Join Two Models

Get a detailed review of the solution to the “Join Two Models” challenge.

We'll cover the following...

Solution

Let’s review the solution to the problem presented in the previous lesson.

shop:
  outputs:
    dev:
      dataset: {{dataset_name}}
      job_execution_timeout_seconds: 300
      job_retries: 1
      keyfile: credentials.json
      location: {{dataset_location}}
      method: service-account
      priority: interactive
      project: {{project_id}}
      threads: 1
      type: bigquery
  target: dev
# Enter your new profile here

Solution code: Joining two dbt models

...