[Solved] Identify the error in this macro definition:{% macro get_orders() %} SELECT * FROM orders — Ans: Missing {% endmacro %} tag to close the macro | dbt

dbt - Jinja in dbt

Identify the error in this macro definition:

{% macro get_orders() %}
SELECT * FROM orders

AMacro name cannot have underscores

BMissing {% endmacro %} tag to close the macro

CSELECT statement must be inside double quotes

DMacro cannot return SELECT statements

Step-by-Step Solution

Solution:

Step 1: Check macro syntax
Macros must start with {% macro %} and end with {% endmacro %} tags.
Step 2: Identify incorrect closing tag
The macro incorrectly uses instead of {% endmacro %}.
Final Answer:
Missing {% endmacro %} tag to close the macro -> Option B
Quick Check:
Macro must end with {% endmacro %} [OK]

Quick Trick: Always close macros with {% endmacro %} [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Identify the error in this macro definition: