How to Decrypt fields for an entire table at once?
Hello, We get a client’s data each week and we try to encrypt the data using encrypt snap and Keystore account. Next, for decryption, we save the encrypted fields for each file into a separate file and append the encrypted new weekly data to the historical table. There’s a huge problem, when we have to decrypt. Since we have encrypted fields saved in a separate file for each weekly file, we can’t decrypt the entire historical table at once for that client. The goal is to have a way be able to decrypt the entire table as and when we need it. Here’s how it looks now: