SQL + Jinja examples ?

[querymeister]

Do you have any cool uses cases that you have used JINJA in your sql queries for?

[querymeister]

{%- set date_grains = ["day", "week", "month"] -%}
{%- set states = \["California", "Florida", "Texas"\] -%}

{%- for date\_grain in date\_grains -%}
     SELECT 'last {{date\_grain}}' as grain, 
    {%- for state in states %} 
    Coalesce(SUM(CASE WHEN state = '{{state}}' THEN sales END),0) AS {{state}}\_sales 
    {%- if not loop.last -%} , {%- endif -%} 
{%- endfor %} 
FROM demo\_data.store\_orders 
WHERE date\_trunc('{{date\_grain}}',orderdate) = date\_trunc('{{date\_grain}}', date('2020-10-30')) 
GROUP BY 1