Skip to main content

Basics for dbts

dbt basics cover the structure of a dbt project and how a model becomes a warehouse object. A model is a SQL file with a select statement, configured in dbt_project.yml, and a materialisation such as view, table, incremental or ephemeral controls whether dbt builds it as a view, a table or something else.

Stage: Foundations · Part of the dbt roadmap · Last reviewed 19 November 2026

What to learn in Basics

Basics interview questions

What does the ref function do in dbt?

ref points to another model by name, and dbt resolves it to the correct schema and table in the current environment. It also records the dependency, so dbt builds models in the right order and can draw the lineage graph.

What is the difference between a view and a table materialisation?

A view stores only the query, so it is always current but recomputes on every read. A table stores the results physically, so reads are faster but data is only as fresh as the last run. Pick by query cost and freshness needs.

Where Basics fits in the dbt roadmap

Basics belongs to the Foundations stage (beginner level), which takes about 15 hours. A dbt project.

Back to the full dbt roadmap