Skip to main content

Project Fundamentals for Analytics Engineers

Project fundamentals in dbt are the building blocks of a transformation project: models written as SELECT statements, sources that declare raw tables, the ref function that wires dependencies, and seeds, snapshots and exposures that handle static data, change history and downstream use.

Stage: dbt in Depth · Part of the Analytics Engineer roadmap · Last reviewed 19 November 2026

What to learn in Project Fundamentals

Project Fundamentals interview questions

What does the ref function do in dbt?

ref points to another model by name, so dbt resolves the correct schema and table for the current environment. It also records the dependency, which determines build order and populates the lineage graph.

When should you use a snapshot?

Use a snapshot when a source table overwrites rows and you need history, for example a customer status that changes. dbt compares the current data with the stored version and records changes with valid-from and valid-to timestamps.

Where Project Fundamentals fits in the Analytics Engineer roadmap

Project Fundamentals belongs to the dbt in Depth stage (intermediate level), which takes about 7 hours. The core craft.

Back to the full Analytics Engineer roadmap