[Solved] Which of the following is the correct way to define a macro in dbt? — Ans: {% macro my_macro() %} SELECT * FROM table {% endmacro %} | dbt

dbt - Jinja in dbt

Which of the following is the correct way to define a macro in dbt?

A{% macro my_macro() %} SELECT * FROM table {% endmacro %}

BCREATE MACRO my_macro AS SELECT * FROM table;

Cdef my_macro(): SELECT * FROM table

Dmacro my_macro() { SELECT * FROM table }

Step-by-Step Solution

Solution:

Step 1: Recall dbt macro syntax
dbt macros use Jinja templating with {% macro %} and {% endmacro %} tags.
Step 2: Match syntax to options
{% macro my_macro() %} SELECT * FROM table {% endmacro %} correctly uses Jinja syntax for defining a macro.
Final Answer:
{% macro my_macro() %} SELECT * FROM table {% endmacro %} -> Option A
Quick Check:
dbt macros use {% macro %} ... {% endmacro %} [OK]

Quick Trick: Look for {% macro %} and {% endmacro %} tags [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Which of the following is the correct way to define a macro in dbt?