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

Sterling Blood

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.

HIlda Davies

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

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0

関連記事

分類Dev

[snowflake python connector ]How to bindings inside a string format

分類Dev

How do I invoke a step function using AWS Lambda ( Python)

分類Dev

Python AWS Lambda信号:スノーフレーク接続中に中止(コアダンプ)(snowflake.connector)

分類Dev

For Snowflake .NET Connector can I get column names in original (Pascal) casing?

分類Dev

How can I edit the region of an aws lambda function already created?

分類Dev

How can i connect Navigation Drawer to activity without using Fragments

分類Dev

Creating a snowflake in Python

分類Dev

How do I add trigger to an AWS Lambda function using AWS CLI?

分類Dev

AzureFunctionsにsnowflake-connector-python [pandas]をインストールする

分類Dev

How can I using Class::Function(params) without static

分類Dev

How do I list all of a user's roles in snowflake DB?

分類Dev

How to remove text from value using SUBSTR in Snowflake?

分類Dev

Python3.xでsnowflake-connector-pythonを使用する際の問題

分類Dev

How snowflake internally performs updates?

分類Dev

Connecting to Snowflake using SSO from JupyterHub running on AWS EC2

分類Dev

How can I connect a subquery without filters to a query with filters?

分類Dev

JAVA 8を使用してAWS Lambda経由でSnowflakeに接続できない

分類Dev

Conditional group by with window function in Snowflake query

分類Dev

snowflake-connector-pythonを使用せずにawslambda関数でsnowflakeに接続するにはどうすればよいですか?

分類Dev

How can I set the function to a state without the function being called?

分類Dev

How to concatenate strings to variables in Snowflake SQL

分類Dev

How to keep only unique rows in Snowflake?

分類Dev

How can I call another Lambda function from current Lambda function?

分類Dev

How can I compile mysql-connector-c for macOS 10.13.x using C?

分類Dev

SnowflakeのLambdaレイヤー関数

分類Dev

Can I do this with data.table without using the merge() function?

分類Dev

How can I utilize AWS::Serverless::LayerVersion in order to use external libraries in my AWS Lambda functions

分類Dev

How can I utilize AWS::Serverless::LayerVersion in order to use external libraries in my AWS Lambda functions

分類Dev

How can I connect to MongoDB Atlas using Robomongo?

Related 関連記事

  1. 1

    [snowflake python connector ]How to bindings inside a string format

  2. 2

    How do I invoke a step function using AWS Lambda ( Python)

  3. 3

    Python AWS Lambda信号:スノーフレーク接続中に中止(コアダンプ)(snowflake.connector)

  4. 4

    For Snowflake .NET Connector can I get column names in original (Pascal) casing?

  5. 5

    How can I edit the region of an aws lambda function already created?

  6. 6

    How can i connect Navigation Drawer to activity without using Fragments

  7. 7

    Creating a snowflake in Python

  8. 8

    How do I add trigger to an AWS Lambda function using AWS CLI?

  9. 9

    AzureFunctionsにsnowflake-connector-python [pandas]をインストールする

  10. 10

    How can I using Class::Function(params) without static

  11. 11

    How do I list all of a user's roles in snowflake DB?

  12. 12

    How to remove text from value using SUBSTR in Snowflake?

  13. 13

    Python3.xでsnowflake-connector-pythonを使用する際の問題

  14. 14

    How snowflake internally performs updates?

  15. 15

    Connecting to Snowflake using SSO from JupyterHub running on AWS EC2

  16. 16

    How can I connect a subquery without filters to a query with filters?

  17. 17

    JAVA 8を使用してAWS Lambda経由でSnowflakeに接続できない

  18. 18

    Conditional group by with window function in Snowflake query

  19. 19

    snowflake-connector-pythonを使用せずにawslambda関数でsnowflakeに接続するにはどうすればよいですか?

  20. 20

    How can I set the function to a state without the function being called?

  21. 21

    How to concatenate strings to variables in Snowflake SQL

  22. 22

    How to keep only unique rows in Snowflake?

  23. 23

    How can I call another Lambda function from current Lambda function?

  24. 24

    How can I compile mysql-connector-c for macOS 10.13.x using C?

  25. 25

    SnowflakeのLambdaレイヤー関数

  26. 26

    Can I do this with data.table without using the merge() function?

  27. 27

    How can I utilize AWS::Serverless::LayerVersion in order to use external libraries in my AWS Lambda functions

  28. 28

    How can I utilize AWS::Serverless::LayerVersion in order to use external libraries in my AWS Lambda functions

  29. 29

    How can I connect to MongoDB Atlas using Robomongo?

ホットタグ

アーカイブ