Reuse Snowflake connections in AWS Lambda?

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/