advanced-jinja-patterns

What problem does it solve?

Writing robust Jinja for dbt models can be error-prone and hard to maintain. This skill provides clear patterns for dynamic SQL generation, macros, adapter-aware logic, and safe compile-time vs run-time behavior to keep models reliable across warehouses.

Core Features & Use Cases

• Reusable Jinja macros and patterns for dynamic SQL generation across warehouses
• Adapter-dispatch aware templates with safe default implementations
• Guidance on compile-time vs run-time behavior and safeguards like execute guards and safe empty-list handling

Quick Start

Refactor a dbt model to use dynamic loops, namespace mutations, and adapter-aware macros with clear separation between compile-time and run-time.