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,
Here, my use case is, i have to decrypt the data which is encrypted say from MySQL RDS. I am trying to use pycryptdome package, by storing whl file as zip file in the S3 bucket and created a library using zip path as mentioned in the https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_LIBRARY.html
Here, i am getting the error as mentioned in the description.
Instead of interfacing different services to decrypt data, Can we use existed redshfit functionality like 'CREATE FUNCTION' and 'CREATE LIBRARY'?
There are particular requirement to be satisfied, refer https://docs.aws.amazon.com/redshift/latest/dg/udf-python-language-support.html#udf-importing-custom-python-library-modules, and refer section
To import a custom Python module into your clusterYes.. i followed same steps for all UDFs. I am facing this error with pycryptodome package when i run the udf.
Then I request you to open a Support Ticket for deeper investigation and troubleshooting.
Thank you. Then i need to raise support ticket only.