Data applications made simple with dbt

{%- set query_params = jinjat.request().query %}

select  order_date, 
        count(*) as orders, 
        count(distinct customer_id) as users
from {{ ref('orders') }} 
group by order_date
where status = '{{query_params.status}}'

% jinjat serve 
INFO     Registering `order_stats` route
INFO:    Uvicorn running on http://127.0.0.1:8581

% curl http://127.0.0.1:8581/0.1/jaffle_shop/order_stats?status=shipped
[
    {"order_date": "2018-01-07", "orders": 102, "users": 80}
]