How to use sql templating in dataset

[smokeriu]

I use SQL lab to create a SQL query like:

SELECT channel_id, created, id
FROM channels
WHERE id = '{{id}}'

And config the parameter:

{
  "id": "C8GMCQ10D"
}

It works fine in sql lab.

But when I try to save the query as a dataset. Superset cannot recognize the variable and instead treats it as regular SQL text. So I got a empty dataset with empty column:

superset version: 4.1.1

[dosubot[bot]]

Hi @smokeriu! I'm here to help you with any bugs, questions, or contributions you have. Let's tackle this issue together!

I found a similar unsolved discussion regarding Jinja templating in Superset datasets. You might find it helpful to check out the Jinja Template discussion ^[1].

To use SQL templating in datasets, ensure that Jinja templating is enabled by setting the ENABLE_TEMPLATE_PROCESSING feature flag in your superset_config.py file:

FEATURE_FLAGS = {
    'ENABLE_TEMPLATE_PROCESSING': True,
}

This configuration allows you to use Jinja templating in queries within SQL Lab and Explore, enabling the embedding of Python code in virtual datasets and custom SQL in filter and metric controls ^[2].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[smokeriu]

I read that discussion, but it didn't solve my problem.

I have the option turned on and it is available in SQL-lab, it just fails after saving as a dataset.