GitHub user alislman21 created a discussion: Unable to Parse SQL When Using
Jinja Templates (Superset 6.0.0.0 + Oracle 19)
Hi everyone,
I’m trying to enable Jinja SQL templating in Superset by following the
sql-templating.mdx documentation. I’ve added the following to my
superset_config.py:
`FEATURE_FLAGS = {
"ENABLE_TEMPLATE_PROCESSING": True
}`
However, when I test a query in SQL Lab, I consistently get the error:
"Unable to parse SQL"
Here is the query I’m running:
`SELECT
"StrategyTitle",
"Years"
FROM "V_STRATEGY_ENTRY"
WHERE 1 = 1
{% if filter_values('DocumentId') %}
AND "DocumentId" IN {{ filter_values('DocumentId') | where_in }}
{% endif %}
ORDER BY "Years"`
Superset Version: 6.0.0.0
Database: Oracle 19
Issue
The Jinja section ({% if filter_values... %}) is not being processed correctly,
and Superset throws an SQL parsing error before executing the query.
Question
How can I fix this? Is there anything additional required for Oracle or
Superset 6.0.0.0 when using Jinja templating in SQL Lab?
Any help would be greatly appreciated!
GitHub link: https://github.com/apache/superset/discussions/37489
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
