GA Runtime Case When Error

[kevin_stricklan]

Hello! I’m currently having some trouble when switching to the new GA Runtime. 

Line of code in question (runs in a derived table):

CASE WHEN ‘{{dimension_name._sql | escape}}’ LIKE ‘%no filter on %’ THEN insert_action_here
ELSE {% condition filter_name %} COLUMN_IN_TABLE {% endcondition %}
END

which Looker translates to:

CASE WHEN ‘(view_name.dimension_name = ‘string_in_question’)’ LIKE ‘%no filter on%’ THEN insert_action_here
ELSE (COLUMN_IN_TABLE = ‘filter_name_value’)
END

This didn’t give any errors prior to using the new runtime and functioned as expected for what ._sql generates.

The error that occurs:

SQL Syntax Error: SQL compilation error: syntax error line 83 at position 53 unexpected 'string_in_question'. syntax error line 83 at position 95 unexpected 'then'. syntax error line 84 at position 10 unexpected 'ELSE'. syntax error line 84 at position 16 unexpected 'COLUMN_IN_TABLE'. syntax error line 85 at position 8 unexpected 'END'.

I suspect that the error may come from this code not following the more strict liquid validations the new runtime executes. 

Any help would be appreciated, and I thank you for taking a look! I hope everyone has a great week.