Hello everyone
We need to add session parameters like before sending query to database
SET enable_hashjoin= off ;
SET enable_mergejoin= off ;
SET work_mem='20GB';
Does anyone knows any way to do this? Any lifehacks?
Thank you!
Hello everyone
We need to add session parameters like before sending query to database
SET enable_hashjoin= off ;
SET enable_mergejoin= off ;
SET work_mem='20GB';
Does anyone knows any way to do this? Any lifehacks?
Thank you!
Hi @Branovitskiy
You set session variables in the JDBC connection string in Admin > Databases > (your-db).
Metabase does not support multi-statements:
https://github.com/metabase/metabase/issues/4050 - upvote by clicking on the first post