Run several queries in one question

Get Help
1

I have a stored procedure that creates a temporary table.
I need to generate that table before the real query starts but i'm unable to do two queries in one question. Any solutions for this? This just generates an error message urging me to read the manual that corresponds to my MariaDB server version for the right syntax to use.

CALL GenerateMyTemporaryTable();
SELECT * FROM TemporaryTable;
2

Hi @snirklebore
Metabase does currently not support multiple statements in a query, but there are some possible workarounds for MySQL/MariaDB:
https://github.com/metabase/metabase/issues/4050 - upvote by clicking :+1: on the first post