Unable to access time_grain in custom SQL

[dipej-reddy]

A clear and concise description of what the bug is.

How to reproduce the bug

1. Go to 'Create Chart'
2. Click on 'METRICS' and select 'Custom SQL' tab

Expected results

Should be able to access time_grain value

Screenshots

[dipej-reddy]

Also trying to use jinja template in custom sql:

SELECT TIME_FLOOR("__time", 'PT15M') AS "__timestamp", '{{ from_dttm }}' - '{{ to_dttm }}' AS "DURATION" FROM "druid"."tableAbc" WHERE "__time" >= '2021-11-29 00:00:00.000000' AND "__time" < '2021-11-30 00:00:00.000000' GROUP BY TIME_FLOOR("__time", 'PT15M') ORDER BY "DURATION" DESC LIMIT 50000;

But, the jinja expression is not getting evaluated

[villebro]

@dneelapareddy have you set the ENABLE_TEMPLATE_PROCESSING config flag to True? See the docs for more info: https://superset.apache.org/docs/installation/sql-templating

[dipej-reddy]

@villebro I have enabled ENABLE_TEMPLATE_PROCESSING to True,
I am able to get the '{{ current_username() }}' from custom sql,

But Jinja template is unable to evaluate '{{ to_dttm }}' - '{{ from_dttm }}' AS Duration

I have even tried it in the SQL lab, but not working there too:

Is there anything else i need to enable to get this working?

[villebro]

Which version are you on? I believe the template processor was until fairly recently only implemented in certain query controls, but should now be universally supported on the current master branch. See also this PR that added more temporal variables to the template processor context: #16680

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[rusackas]

Closing due to lack of follow-up details after over a year. If this is still an issue, holler and we can re-open!

[villebro]

FYI this should be fully resolved on master branch (I can dig out the PRs if needed)