How can I connect to snowflake in aws lambda function without using snowflake-connector-python?

user_12166502 0
Viewed 1278

I want to be able to connect to snowflake using the snowflake-connector-python package but it is too large when it is packaged up. The maximum unzipped size for lambda's is 250 MB and just installing snowflake-connector-python (latest version) brings in pyarrow and numpy which are very large. The deployment package unzipped is 324 MB. What other options do I have?

UPDATE:

I have moved to version 1.9.0 and am receiving multiple errors. It looks like the following thread has the same issue.
https://community.snowflake.com/s/question/0D50Z00009bTn7ASAS/cant-establish-a-connection-using-snowflakeconnectorpython-v19?t=1570467024620&searchQuery=#

UPDATE:

Moving to version 1.9.0 with asn1crypto<1.0.0 (0.24.0) worked for me.

aws-lambda snowflake-cloud-data-platform python
1 Answers

We are aware if this issue and our engineers are actively looking at this. The current recommended workaround is for you use use version 1.9.0 instead of version 2.0. This should bring the size back down to a size acceptable for lambda deployment.

Hope this helps

user_121469630
Related