Dashboard subscription with dynamic variables query


I'm in a middle of a PoC with Metabase solution in order to replace my current BI/reporting tool, and I need help with an issue I'm facing.

I have a SQL query saved in Metabase collection which is basically a call to a stored procedure in my SQL server.
I configured a variable which I intend to run with different values. Now my question is, can I create a dashboard based on this query, and make multiple subscriptions to this dashboard but with each subscription to pass a different variable to this dashboard?

If the first flow is not supported, can I even make multiple dashboards based on this query and pass the variable in the dashboard level?

I couldn't find any answer to both scenarios so any help will be very appreciated.