We are using metabase with H2 database for developing charts for our client. customer database is MSSQL Server. while making charts using stored procedures we are facing few issues.
-
a stored procedure returning data while running on sql server is showing empty result set when same is used in Metabase as query.
-
during each refresh, same stored procedure is returning different values. (no such issue while running directly).
caching is disabled in metabase admin settings.