Authentification Token Has Expired. The user must authentificate again

KNIME Analytics Platform
1

Hi!

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?

Authentification%20Token%20has%20expired
Authentification%20Token%20has%20expired819×460 8.82 KB

2

Hi @razvancomanici,

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

2 Likes
3

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!

4 Likes
4