1

I would like to check if it is possible to use Redash filter parameters to turn on/off code in my Presto query.

Sample code I tried: shown below. Basically, I want to union queries only if the filter value is 'a'.

select 1 col
{% if '{{dummyfilter}}'='a' %} union select 100 {% end %}

Error shown: Error running query: line 2:1: mismatched input '{'. Expecting: ',', 'EXCEPT', 'FETCH', 'FROM', 'GROUP', 'HAVING', 'INTERSECT', 'LIMIT', 'OFFSET', 'ORDER', 'UNION', 'WHERE',

Guru Stron
  • 102,774
  • 10
  • 95
  • 132
Mel
  • 11
  • 1

0 Answers0