For some time I’ve been using the snowflake database.
The problem is that the next day when I want to connect to this database again, the error “Authentification token has expired.” The user must authenticate again.
So I have to close and reopen Knime in order to use the database again.
How can I solve this issue?
this seems to be a feature of the snowflake. There are several discussions that can be googled, but as an example see https://support.snowflake.net/s/question/0D50Z00006uSiDlSAK/authentication-token-expired-issue. Basically, if the connection is idle for 4 hours the token is not renewed
I stumbled across a syntax to add to the Database URL in the DB Connector node.
Basically you add “&CLIENT_SESSION_KEEP_ALIVE=true” to the end of the URL. Link here: https://medium.com/@craigcullum/knime-️-snowflake-301d1dfe4234
This has seemed to work for me with Snowflake!