Reuse Snowflake connections in AWS Lambda?

Question

[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?

Answer

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/

Reuse Snowflake connections in AWS Lambda?

Relevant content