How to add database session parameters into separate question?

Hello everyone :slight_smile:

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 :+1: on the first post

1 Like