UDF for encryption and decryption in redshift

Question

I need to create a aes encryption ECB UDF in the redshift. To achieve this, i have imported pycryptodome zip file in the S3 with the name Crypto.zip and create library in the redshift.

When i try to use this UDF, i am getting, the below error:
```
ERROR: OSError: Cannot load native module 'Crypto.Cipher._raw_ecb': Not found '_raw_ecb.so', Not found '_raw_ecbmodule.so'. Please look at svl_udf_log for more information Detail: ----------------------------------------------- error: OSError: Cannot load native module 'Crypto.Cipher._raw_ecb': Not found '_raw_ecb.so', Not found '_raw_ecbmodule.so'. Please look at svl_udf_log for more information code: 10000 context: UDF query: location: udf_client.cpp:366 process: 
```
I need to use pycryptodome pip package only,

bambangraharjo · Answer

Hi,

Did you manage to resolve this issue? We’re currently trying to install **pycryptodome** and encountered the same error. If you’ve successfully solved it, could you kindly share the solution with us? Thank you!

MilindOke · Answer

Take a look at this sample https://github.com/aws-samples/implement-column-level-encryption-in-amazon-redshift-with-aws-glue-and-aws-lambda-udf , it leverage AWS Lambda and you can use layers (https://docs.aws.amazon.com/lambda/latest/dg/chapter-layers.html) for your custom code.

UDF for encryption and decryption in redshift

Relevant content