deliverr / data-knex-snowflake-dialect

knex.js dialect for the Snowflake data warehouse
MIT License
13 stars 26 forks source link

BEGIN; - Unable to perform operation using terminated connection. #16

Closed iorlenko closed 3 years ago

iorlenko commented 3 years ago

Connection is getting staled after some inactivity period and knex stops working

emurphy commented 3 years ago

This problem applies generally to Snowflake connections on nodejs, see for example: https://community.snowflake.com/s/question/0D50Z00008xA6PESA0/unable-to-perform-operation-using-terminated-connection-using-nodejs-error-unable-to-perform-operation-using-terminated-connection