Decrypting PostgreSQL data in Looker and then doing calculations

[schak_looker]

We have few data in PostgreSQL DB which is in encrypted format. We could able to decrypt data using pgcrypto module and show it in Looker (for a set of admin users). However we are not able to do any calculations like aggregate etc. on that set of encrypted data. Any help on how to resolve this issue. 

[Dawid]

What exactly do you want to resolve?  You can’t aggregate encrypted data.

I’m assuming you don’t want to decrypt the data in your data model because of too many eyes.

Possibly you could create an PDT in Looker that creates a decrypted dataset (make sure people using your warehouse do not have access to that table), make it persistent (the name won’t change), and attach it to your explore with some access grants