dbt Macros Library Cheat Sheet

Share parametric SQL

Last Updated: November 21, 2025

Focus Areas

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

Commands & Queries

{% macro audit_status() %}...{% endmacro %}
Define
{{ audit_status() }}
Call
dbt ls --macro
List

Summary

Macro libraries reduce duplicated SQL.

💡 Pro Tip: Document inputs/outputs for each macro.
← Back to Data Science & ML | Browse all categories | View all cheat sheets