Jinja templates not working in superset 1.0 rc1

[lilila]

Queries using Jinja variables are not working anymore in Superset 1.0 rc1.

For instance I have a dataset defined as follows :

{% set title_target = ' "'  + filter_values("title_target", 'Joker')[0] + '" ' %}
{% set title_type =  'title' %}

{% if filter_values('title_target_original')|length > 0 %}
    {% set title_target =  ' "'  + filter_values("title_target_original", 'Joker')[0] + '" ' %}
    {% set title_type =  'title_original' %}
{% endif %}


SELECT {{title_target}} AS title_to_display

I use to work well but now I receive the following error:

Error: (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'%\n set title_target = \' "\' + filter_values("title_target", \'Joker\')[0] + \'" \' \' at line 4')

If I move the Jinja parameters in the "template parameters" section:

I receive the following error:
Expecting property name enclosed in double quotes: line 1 column 2 (char 1)

[junlincc]

@lilila thanks for reporting, we will get to it asap!

[villebro]

Thnks for reporting @lilila , going to work on this now.

[villebro]

@lilila I'm not able to reproduce the first case - I assume you've enabled the template processing feature flag?

FEATURE_FLAGS = {
    "ENABLE_TEMPLATE_PROCESSING": True,
}

See #11172

[lilila]

@villebro , No I didn't , works when enabled ! Sorry and thank you

[villebro]

Great, no worries!

[annibac]

Just a quick question , how do I include this with Helm?
I tried to add this in values.yaml, but it seems to be ignored :

configOverrides: my_override: | FEATURE_FLAGS = { "ENABLE_TEMPLATE_PROCESSING": True }

When I try to use {{ filter_values("sampling")[0] }} I get the following postgresql error : Postgresql Error : syntax error at or near "{"

[abhiroop93]

Have the same question, how do I include this with Helm?

[annibac]

Hello !
I just found a way

In your folder, go to superset > template : there is a "_helpers.tpl" file which contains the superset_config.
Just add at the end:

FEATURE_FLAGS = {
    "ENABLE_TEMPLATE_PROCESSING": True,
}

And this will work. Not sure if this is the best way to do it, but works for me for now.

[abhiroop93]

Thanks Celine!
There is a slightly better place of putting it, you can just include it in the configOverrides section in values.yaml like below:

configOverrides: {}
  enable_oauth: |
     FEATURE_FLAGS = {
        "ENABLE_TEMPLATE_PROCESSING": True,
     }

[mona-mk]

I think the correct place with docker nowadays is here:

[NikosSpanos]

@lilila I'm not able to reproduce the first case - I assume you've enabled the template processing feature flag?

FEATURE_FLAGS = {
    "ENABLE_TEMPLATE_PROCESSING": True,
}

See #11172

Should be added on superset_config.py file and NOT on config.py file

[NikosSpanos]

I think the correct place with docker nowadays is here:

This is the way to make it work. Kudos!

[blackmamba-ops]

@lilila I'm not able to reproduce the first case - I assume you've enabled the template processing feature flag?

FEATURE_FLAGS = {
    "ENABLE_TEMPLATE_PROCESSING": True,
}

See #11172

Should be added on superset_config.py file and NOT on config.py file

Didnt worked for me even after enabling

"ENABLE_TEMPLATE_PROCESSING": True