SNOW-1062439: Automatically closing sessions and connections using Python with leads to errors when deploying to stored procedures

SNOW-1062439: Automatically closing sessions and connections using Python with leads to errors when deploying to stored procedures #1072