Use Custom Environment Variables Inside Metabase SQL Query

HI!

I am currently decrypting a column inside my postgresql database everytime I run a query inside metabase, at first it is okay since I was the only user, now that others would start viewing and utilizing the SQL Questions, I want to hide my decryption keys from plain site.

I was thinking if there is a way were I could add an environment variable pointing to the decryption keys, so that other users would just refer to that environment variable everytime they need to decrypt the encrypted columns.

Thanks!

For completely different reasons I would also like to use OS environment variables.

For me a reasonable alternative would be to iterate over a column’s distinct values and run a report/question for each value.