dbt Macros Library Cheat Sheet

dbt Macros Library — a quick reference covering core concepts, practical examples, and best practices.

Last Updated: November 21, 2025

Focus Areas

Focus
Group macros in `macros/`
`Call macros with explicit args`


         {% macro audit_status() %}...{% endmacro %}

Define


         {{ audit_status() }}

Call


         dbt ls --macro

List

Macro libraries reduce duplicated SQL.

💡 Pro Tip: Document inputs/outputs for each macro.