Project Development Flashcards

What does the selector +orders+ do in dbt run --select +orders+?

Answer: Runs orders plus all its ancestors and all its descendants

A leading + includes upstream parents and a trailing + includes downstream children.

You need to document that a Tableau dashboard depends on several marts so it appears in the lineage graph. Which resource should you define?

Answer: An exposure

Exposures declare downstream uses of dbt models, such as dashboards, and appear in the DAG.

A model contract is enforced with contract: {enforced: true}. What must be defined for the model?

Answer: Every column's name and data_type in its YAML

Enforced contracts require column names and data types, and dbt validates them before building.

In a dbt Mesh setup, a model is configured with access: private inside a group. Who can ref() it?

Answer: Only models in the same group

Private models can only be referenced by models belonging to the same group.

Which Jinja variable lets a macro avoid running introspective queries during dbt's parse phase?

Answer: execute

execute is false during parsing, so wrapping run_query calls in {% if execute %} prevents errors.

You need to call a macro from the CLI to perform a one-off operation such as dropping old schemas. Which command do you use?

Answer: dbt run-operation drop_old_schemas

dbt run-operation invokes a macro directly with optional --args.

A model's SQL uses {{ ref('stg_orders', v=2) }}. What feature is being used?

Answer: Model versions

Model versions let you ref a specific version of a model while migrating consumers.