A template can produce valid SQL and still encode the wrong rule. These tasks ask you to generate projections, share expressions, and select environment-specific behavior.
Inspect both the template and the SQL it renders. A Jinja filter changes template values; a SQL function changes warehouse values.
The fixtures include an empty column list, an exact threshold, and missing fee amounts. Each one needs a deliberate result.
Keep macro defaults stable when one caller needs a different label, and preserve the distinction between a required deployment variable and an optional value with a fallback. The final incident asks you to use the compilation error to choose the correct repair.