Parameterizing schema and object name

1

I am trying to parameterize env ( ST/QA) in some Metabase question’s. When I run with env or object name as parameter it gives error as Schema db_$1 does not exists. Looks like it is unable to replace the parameter value at schema or object name.
example -

SELECT e_name from db_{{env}}.emp where id = 123
– input value = st

or

SELECT e_name from {{env}} where id = 123
– input value = db_st.emp

Any idea if we can parameterize the schema and table/view name?

2

A similar(?) feature request:

edit: hmm more Anyway to add dynamic table name in SQL template? related How do I select which database a query or database gets run against? topics in here … Let’s link stuff together!