My goal is to have a Metabase dashboard filter (e.g., a dropdown or input field) that gets its values from a stored procedure result. Instead of using a static query or table/view, I want to run a stored procedure, extract its output, and use that as the source for filtering data across one or more dashboard cards. Is it possible to use?
Please don’t use stored procedures for analytics, you’ll save yourself from tons of headaches
Hi Luiggi, But for my use case, it is essential. Does it work as a Dynamic Filter input for Dashboard?
Your stored proc needs to return a table for Metabase to use it as a filter input. Can you modify or write a new procedure to return a table?
I can do that, is this the only way?
Probably?
What database are you using?
SQL server
I think a TVF is the way to go here.
If the values don't change that frequently you could use a materialized view.