We have had some issues with closing connections with Snowflake causing things to hang. Hopefully this is helpful.
Here is a PR we’re working on for Snowflake to make sure connections are closed correctly.
This is the link to the Snowflake Documentation that describes their specific requirements for closing connections and disposing engines.
https://docs.snowflake.com/en/user-guide/sqlalchemy.html#connection-string-examples