Any way to run a statement for each connection?

I want to run a statement for each session/connection. Redshift finally added better support for JSON, which I'd love to be able to use, but I need to SET enable_case_sensitive_identifier to TRUE; to make it work.

There seems to be no way to put that in each query (which makes sense, query being just one statement makes sense), but I'd really love if there was a way to configure Metabase to just automatically run my statement for me for each session. I'm happy to have this globally set.

Is there a way to achieve what I need?

Hi @wghm
Until the Redshift driver supports Connection String, then I think the only way would be a procedure.
https://github.com/metabase/metabase/issues/9695 - upvote by clicking :+1: on the first post

1 Like