[Solved] How do you correctly define a macro called calculate_total in dbt? — Ans: {% macro calculate_total() %} SELECT SUM(amount) FROM sales {% endmacro %} | dbt

dbt - Jinja in dbt

How do you correctly define a macro called calculate_total in dbt?

Adef calculate_total(): SELECT SUM(amount) FROM sales

Bmacro calculate_total() { SELECT SUM(amount) FROM sales }

C{% macro calculate_total() %} SELECT SUM(amount) FROM sales {% endmacro %}

D<macro name="calculate_total"> SELECT SUM(amount) FROM sales </macro>

Step-by-Step Solution

Solution:

Step 1: Identify dbt macro syntax
dbt macros are defined using Jinja templating with {% macro macro_name() %} ... {% endmacro %} tags.
Step 2: Check each option
{% macro calculate_total() %} SELECT SUM(amount) FROM sales {% endmacro %} uses correct Jinja syntax for macros. Options B, C, and D use invalid syntax not supported by dbt.
Final Answer:
{% macro calculate_total() %} SELECT SUM(amount) FROM sales {% endmacro %} -> Option C
Quick Check:
Correct Jinja macro syntax uses {% macro %} and {% endmacro %} tags [OK]

Quick Trick: Use {% macro name() %} ... {% endmacro %} for macros [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

How do you correctly define a macro called calculate_total in dbt?