[Jeremy Daly talks about reusing RDS connections in AWS Lambda](https://www.jeremydaly.com/reuse-database-connections-aws-lambda/). I assume this principle of establishing the connection outside of the Lambda handler's context would work for Snowflake connections too?

Reuse Snowflake connections in AWS Lambda?

Jeremy Daly talks about reusing RDS connections in AWS Lambda. I assume this principle of establishing the connection outside of the Lambda handler's context would work for Snowflake connections too?

주제

서버리스 컴퓨팅 데이터베이스

태그

서버리스 AWS Lambda 데이터베이스

언어

English

yann_stoneman

질문됨 일 년 전200회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

Hi there,

The general advice for any SDK clients and database connections would be to initialize them outside of the function handler, and cache static assets locally in the /tmp directory. Subsequent invocations processed by the same instance of your function can reuse these resources. This saves cost by reducing function run time.

This would also apply to third-party database tools such as Snowflake.

Should you wish to learn more about how Lambda may re-use it's containers, please see [1].

Thank you,

Ahmad

[1] https://aws.amazon.com/blogs/compute/container-reuse-in-lambda/

Ahmad Tariq

답변함 일 년 전

Reuse Snowflake connections in AWS Lambda?

관련 콘텐츠