I have multiple SQL server functions (that returns tables), some of them are requiring parameters to execute. How can I use them as source of data for Questions - I would like to have ability to filter, sumarize, …
Currently when I open questions only SQL server tables are listed
Also, this applies also for SQL stored procedures that return data
Thanx,
D
Hi @dinon
You have two options (probably more):
Create a database view, so Metabase sees a “real” table - this is recommended to get the full usage of Metabase.
Or use the Saved Question, meaning you use the SQL question as base when creating a Simple question, which will give you some functionality, but there’s limitations to that.
https://www.metabase.com/docs/latest/users-guide/custom-questions.html#picking-your-starting-data