How dbt works (SQL + Jinja + YAML) - Quick Revision & Summary

Recall & Review

beginner

What is dbt and what does it do?

dbt (data build tool) helps analysts and engineers transform data in their warehouse by writing SQL queries, organizing them, and running them in order.

beginner

How does dbt use SQL in its workflow?

dbt uses SQL files to define transformations. Each SQL file represents a model that creates a table or view in the data warehouse.

intermediate

What role does Jinja play in dbt?

Jinja is a templating language used inside dbt SQL files to add logic like loops, conditions, and variables, making SQL dynamic and reusable.

intermediate

Why does dbt use YAML files?

YAML files in dbt are used to configure models, define tests, document data, and set metadata like descriptions and tags.

advanced

How do SQL, Jinja, and YAML work together in dbt?

SQL defines the data transformations, Jinja adds dynamic logic inside SQL, and YAML configures and documents the models. Together, they make dbt projects organized, flexible, and maintainable.

What does a dbt model usually represent?

A A Python script

B A SQL file that creates a table or view

C A Jinja template only

D A YAML configuration file

In dbt, a model is a SQL file that defines a transformation creating a table or view.

Which language does dbt use to add logic inside SQL files?

A Python

B YAML

C Jinja

D JavaScript

dbt uses Jinja templating language to add logic like loops and conditions inside SQL.

What is the main purpose of YAML files in dbt?

A To execute Python code

B To write SQL queries

C To run data transformations

D To configure models and tests

YAML files in dbt configure models, define tests, and add documentation.

How does dbt run your data transformations?

A By running SQL queries defined in models

B By compiling YAML files

C By executing Python scripts

D By using JavaScript functions

dbt runs the SQL queries you write in models to transform data in your warehouse.

Which of these is NOT a function of Jinja in dbt?

A Defining model metadata

B Adding loops and conditions in SQL

C Using variables inside SQL

D Making SQL reusable

Defining model metadata is done in YAML, not Jinja.

Explain how SQL, Jinja, and YAML work together in a dbt project.

Think about how each language contributes to building and managing data models.

Describe the role of Jinja templating in making SQL dynamic within dbt.

Consider how you might write one SQL file that can change based on inputs.