DBT DBT Sources & Seeds 2

Question 1

How do you reference a seed table inside a dbt model?

Accepted Answer

Answer

Answer

Answer

Question 2

Where are source definitions typically stored in a dbt project?

Accepted Answer

In YAML files within the models/ directory

Answer

In dbt_project.yml

Answer

In a dedicated sources.yml at the project root

Answer

In the macros/ directory

Question 3

What does the `loaded_at_field` property on a source table specify?

Accepted Answer

The column that holds the row's creation timestamp for freshness checks

Answer

The field used to partition the source table

Answer

The primary key of the source

Answer

The field mapped to the dbt surrogate key

Question 4

Which config key in dbt_project.yml sets the schema for all seed tables?

Accepted Answer

seeds > +schema

Answer

seeds > +database

Answer

seeds > +target_schema

Answer

seeds > +materialized

Question 5

What happens when you run `dbt seed --full-refresh`?

Accepted Answer

The seed table is dropped and recreated from scratch

Answer

Only new CSV rows are appended

Answer

Indexes are rebuilt

Answer

Source tables are re-imported

Question 6

Which dbt source property lets you override the actual database table name that a source points to?

Accepted Answer

identifier

Answer

alias

Answer

table_name

Answer

override