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
- Write a model and reference another with the ref function
- Declare a source and use the source function
- Load a small lookup table with a seed file
- Capture row history with a snapshot
- Declare an exposure for a dashboard that depends on a model
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.
Other units in this stage
Back to the full Analytics Engineer roadmap