dbt Macros & Jinja

When to Use

Activate this skill when the task involves:

• Writing dbt macros from scratch or improving existing ones
• Using Jinja control flow, filters, and variables in dbt SQL
• Implementing cross-database macros with adapter.dispatch
• Dynamic SQL generation via run_query / execute
• Overriding built-in dbt macros (generate_schema_name, generate_alias_name)
• Writing macros that call adapter methods (schema introspection, DDL)
• Organizing macros across files and packages

Jinja Fundamentals

Three Delimiters