DBT DBT Macros & Jinja

Question 1

Which delimiter is used in Jinja to output a value in dbt SQL files?

Accepted Answer

Answer

{% ... %}

Answer

{# ... #}

Answer

<< ... >>

Question 2

What Jinja delimiter is used for control flow statements like `if`, `for`, and `set` in dbt?

Accepted Answer

{% ... %}

Answer

Answer

{# ... #}

Answer

{$ ... $}

Question 3

How do you define a reusable macro in dbt?

Accepted Answer

Define it with {% macro name(args) %} ... {% endmacro %} in the macros/ folder

Answer

Create a function in models/macros.sql

Answer

Add it to dbt_project.yml under macros:

Answer

Use the def keyword in a .py file

Question 4

What built-in dbt variable returns the current target name (e.g., 'dev' or 'prod')?

Accepted Answer

Answer

Answer

Answer

Question 5

Which dbt Jinja function safely reads an environment variable and supports a default value?

Accepted Answer

Answer

Answer

Answer

Question 6

What does `{{ this }}` refer to inside a dbt model?

Accepted Answer

The relation (schema.table) of the model currently being built

Answer

The dbt project object

Answer

The current Jinja context

Answer

The source table being referenced