Forum Discussion
Decrypt Column in Power Query from Snowflake
Hi I have encrypted a column called [ENCR_NOTE] in Snowflake using the encrypt built in function. I have loaded the data in Power Query and I m trying to now decrypt it. How can I decrypt...
Yes it is select *, to_varchar(decrypt(encr_note, 'xxxx'), 'utf-8') notes
from finrep_dev.treasury.cash_balance_fact_encr_pbi
And I have now managed to decrypt them . The challenge for me now is to manage to decrypt with a passphrase. Please help me with that...any ideas?
You can use parameters to supply the passphrase. Obviously that is not safe. You could also store the passphrase elsewhere like a SharePoint document library with restricted access. Doing that will likely result in issues with the formula firewall.
