Introduction to dbt

Start Free Preview

Buying via our links supports this free directory · Affiliate disclosure.
Course facts
  • Payment: Free Preview (Paid Upgrade)
  • Learning style: Self-paced, start anytime
  • Format: Text & Interactive
  • Video access: Streaming Only
  • Before you start: Data Warehousing Concepts; Introduction to Shell; Joining Data in SQL
DataCamp details
  • Chapters: 3
Created byDataCamp
Available onDataCamp

Course Details
Learning Style

Start Anytime

Level

Intermediate

Study Mode

100% Online

Duration

Short (< 10 Hours)

Languages
Audio Language

English

Outcomes
Certificate

Certificate of Completion

Price & Terms
Pricing Model

Free Preview (Paid Upgrade)

Technical
Content Medium

Text & Interactive

Video Access

Streaming Only

Specification
Access

Subscription

Set up a dbt project, write SQL models, template them with Jinja and order them with ref, through interactive SQL and shell exercises.

At a glance
Duration4 hrs
LevelIntermediate
CertificateCertificate of Completion
LanguageEnglish
Taught byMike Metzger
AccessSubscription
Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare

dbt, the data build tool, organizes the extract, load and transform work of a data warehouse into a project of SQL-based models, with declared dependencies that make the models execute in the correct order. You learn what dbt is and when it should be used, then set up a project and its profile, create, update and troubleshoot models, simplify them with Jinja templates, and generate documentation for the result.

What You Will Achieve

  • Initialize a dbt project, create its profile and run it with the dbt command
  • Write SQL-based dbt models, adjust their config files and troubleshoot models that fail
  • Use the ref function to declare hierarchical dependencies so models execute in the correct order
  • Simplify repeated model code with Jinja templates and generate documentation for a project


Program Overview

Foundations of dbt and Project Setup

Why dbt exists, who uses it, and how a new project is created and configured before any models are written.

  • The dbt command, versions and getting help
  • Users of dbt
  • Initializing a project
  • Creating a project profile

Building and Updating SQL Models

What a dbt model is and the workflow for creating, running and changing models inside a first project.

  • dbt project workflow
  • Features of a data model
  • Creating and updating models
  • Config files and model issues

Documentation, Jinja Templates and Model Hierarchies

Generating project documentation, templating models with Jinja and ordering execution through hierarchical dependencies.

  • dbt docs command options
  • Documentation flow
  • Processing Jinja templates
  • Hierarchical model creation with ref

Certificate Awarded (Paid)


Job Outlook

dbt skills are used wherever teams build and maintain data warehouses, in data analyst, data engineering and analytics engineering work that turns loaded data into modeled, documented tables.


Our take

Good for: SQL users who already load data into a warehouse and want a structured, repeatable way to write and order their transformations.

Keep in mind: Building tests is named as a goal, yet no lesson covers it: the chapters center on project setup, models, Jinja templates, documentation and model hierarchies.

Bottom line: Its SQL and shell exercises cover the core dbt loop of initializing a project, writing models and declaring the order they run in.

Frequently Asked Questions

What is a dbt model?

In this course a dbt model is a SQL-based model inside a dbt project that transforms data. The lessons cover the features of a data model, how to create, update and troubleshoot one, and the config files around it.

How does dbt decide the order in which models run?

You declare the dependencies between models with the ref function, which builds a hierarchy. dbt then runs models in that order, and the last chapter has you create and update such hierarchies.

Which tools do the exercises use?

The exercises use SQL to write models and shell commands to run dbt, its documentation commands and project setup, working with real datasets inside an example data warehouse.

Is the course tied to one kind of data warehouse?

The exercises implement a single example warehouse, but the course presents its material as a foundation that applies whichever type of data warehouse you plan to build with dbt.

User Reviews

0.0 out of 5
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0

No reviews yet. Be the first to review this course.

There are no reviews yet.

Write your review

Reviews can only be posted by registered learners. Log in, then you will return here to post.

×

    Report this page
    LiveTalent
    Logo
    Compare items
    • Total (0)
    Compare
    0