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: