Support Questions

Find answers, ask questions, and share your expertise

NiFi EncryptContent with SHA256_256AES decrypt in Snowflake

New Contributor

Hi, I have a simple task that is not so obvious when trying to get things done. I have to encrypt flowfiles with SHA256_256AES before puting in on S3 bucket and later decrypt it with Snowflake.

When using SHA256_256AES I need to provide password and optionally Raw Key (hexadecimal) and Snowflake requires 128,192 or 256 bits key.

My question is: is NiFi generating key itself when none is provided? Or do I have to generate key myself somehow? Below I attach processor configuration.

Screenshot 2019-10-31 at 09.56.31.pngScreenshot 2019-10-31 at 09.59.02.png

The key specified in query is exemplary to show accepted length.

2 REPLIES 2

New Contributor

Was this issue resolved, How can we use encrypt processor in NiFi and Decrypt the same in Snowflake

Expert Contributor

In response to the question is NiFi generating key itself when none is provided? Or do I have to generate key myself somehow?

Answer is : Raw Key (hexadecimal) property only used when given algorithm uses Keyed cipher for example : AES_CBC, it has to be provided by user , Not generated automatically, based on processor configuration screen shot , password is only needed in NIFI and , same password should be used while  decrypting with in NIFI by same processor with Mode: Decrypt or any other decrypting application.