Use Custom Environment Variables Inside Metabase SQL Query


#1

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!


#2

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.