DBT Core Concepts & Architecture Flashcards

What is the primary purpose of the `ref()` function in dbt?

Answer: To reference another dbt model and build the DAG dependency graph

The `ref()` function references another dbt model and allows dbt to infer dependencies, building the correct DAG execution order automatically.

Which file defines top-level project configuration such as model paths, project name, and version in dbt?

Answer: dbt_project.yml

`dbt_project.yml` is the required project-level configuration file that defines project name, version, model directories, and global configurations.

What does the `dbt compile` command do?

Answer: Generates compiled SQL files without executing them against the database

`dbt compile` resolves Jinja templating and `ref()` calls to produce compiled SQL in the `target/compiled/` directory without running any queries.

In dbt, what does a DAG (Directed Acyclic Graph) represent?

Answer: The dependency relationships and execution order between models

The DAG in dbt represents the dependency graph between models, ensuring each model is built only after all its upstream dependencies are complete.

Which command executes all dbt models in a project?

Answer: dbt run

`dbt run` executes all models in the project, materializing them in the target data warehouse according to their configured materialization type.

What is the default materialization type for dbt models when none is explicitly configured?

Answer: view

By default, dbt materializes models as views unless overridden in `dbt_project.yml` or a model's config block.

Where are dbt connection credentials and target environment settings typically stored?

Answer: profiles.yml

`profiles.yml` stores database connection credentials and target configurations, typically located in `~/.dbt/` to keep secrets out of version control.