Jinja templating is ignored in Metrics definitions

[rmacnguyen]

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

Superset version

0.29.0rc7 (latest on pypi)

Expected results

Not sure if this is intentional, but it seems like Jinja templating used when defining metrics using custom SQL should be parsed and rendered similarly to how it works when defining filters.

Actual results

Jinja templating in metrics is effectively ignored and sent to the query engine as is.

Steps to reproduce

Add a metric to a chart that includes Jinja templating. For example, define a metric as max('{{ from_dttm }}'). The rendered SQL shows that the templating is ignored.

[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.

[quest-platform-admin]

Has this been looked into @junlincc?

[mistercrunch]

Confirming this is still an issue, reopening & pinning

[guydou]

This is how I solved it in my use-case #15502