Next steps - Data Build Tool (dbt) Tutorial

Contents

• Introduction Introduction

  • Build your first dbt project

    52s
  • Introducing the dbt project

    2m 22s
  • (Locked)
    The project in GitHub Codespaces

    1m 9s
• 1. Prepare Your Coding Environment 1. Prepare Your Coding Environment

  • Install the dbt Core via pip

    52s
  • (Locked)
    Install the dbt connector to DuckDB

    1m 10s
  • (Locked)
    Install DuckDB via pip

    44s
  • (Locked)
    Update your requirements.txt file within your project

    50s
• 2. Prepare Your Database Environment 2. Prepare Your Database Environment

  • Create your database file

    2m 42s
  • (Locked)
    Import CSV data into your new database

    3m 28s
• 3. Create a dbt Project 3. Create a dbt Project

  • (Locked)
    Start your project with dbt init

    1m 35s
• 4. Prepare Your dbt Environment 4. Prepare Your dbt Environment

  • (Locked)
    Understand the dbt_project.yml file

    1m 44s
  • (Locked)
    Create your profiles YAML file

    2m 2s
  • (Locked)
    Connect your profiles and project YAML files

    2m 19s
• 5. Your First dbt Model 5. Your First dbt Model

  • (Locked)
    Create your first dbt model file

    1m 45s
  • (Locked)
    Using the dbt CLI commands

    3m 32s
• 6. Introduction to dbt Ref Function 6. Introduction to dbt Ref Function

  • (Locked)
    Create your dbt model utilizing ref

    2m 22s
  • (Locked)
    Run your dbt models with the ref syntax

    1m 24s
  • (Locked)
    View your dbt project data lineage

    2m 6s
• 7. Implementing Medallion Architecture with dbt 7. Implementing Medallion Architecture with dbt

  • (Locked)
    Planning your medallion architecture project

    57s
  • (Locked)
    Medallion architecture: Bronze data

    4m 23s
  • (Locked)
    Medallion architecture: Silver data

    5m 45s
  • (Locked)
    Medallion architecture: Gold data

    3m 34s
• 8. Materialization of dbt Models 8. Materialization of dbt Models

  • (Locked)
    Materialization in your dbt project

    1m 55s
  • (Locked)
    Implement materialization in your dbt_project.yml file

    2m 12s
• 9. Documentation as Code via dbt 9. Documentation as Code via dbt

  • (Locked)
    Further documentation via schema.yml file

    3m 22s
  • (Locked)
    The docs_blocks.md file

    4m 50s
• 10. Implementing Tests within Your dbt Project 10. Implementing Tests within Your dbt Project

  • (Locked)
    Creating custom singular tests

    3m 26s
  • (Locked)
    Implementing tests within the schema.yml file

    3m 49s
• 11. Deploying Your dbt Project 11. Deploying Your dbt Project

  • (Locked)
    Utilizing multiple dbt profiles

    3m 7s
  • (Locked)
    Deploying with GitHub workflows

    5m 8s
• Conclusion Conclusion

  • (Locked)
    Next steps

    39s