79377691

Date: 2025-01-22 12:30:05
Score: 0.5
Natty:
Report link

To add those parameters you have to:

In my example I have this query

SELECT order_number, order_date, sales
FROM cleaned_sales_data 
WHERE TRUE
    {% if from_dttm is not none %}
      AND order_date > '{{ from_dttm }}'
    {% endif %}
    {% if to_dttm is not none %}
      AND order_date < '{{ to_dttm }}'
    {% endif %}

and I added the following parameters:

{
"from_dttm": "2003-05-01",
"to_dttm": "2003-06-01"
}

enter image description here

and then you get the proper results based on the given parameters

enter image description here

Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Letsios Matthaios