Auth Error Snowflake

[samanvi]

HI Every one,

One of my sas code is connecting to snowflake and keep executing  for long time after 4 hrs the session is getting disconnected and sas job is getting failed with error

"ERROR:CLI PREPARE ERROR AUTH TOKEN EXPIRED, uSER MUST AUTH AGAIN"

Could you help me how to keep session active.

[SASJedi · Accepted solution]

Is your program assigning the Snowflake LIBNAME early in the code, then doing a lot of other stuff that doesn't use Snowflake data? According to this Snowflake forum article, your error message indicates that your Snowflake session has gone more than 4 hours without activity. They Do mention that you could use the CLIENT_SESSION_KEEP_ALIVE option to extend the session timeout. The LIBNAME Statement for Snowflake documentation provides a CONOPTS statement option that can be used to specify additional Snowflake connection options like this one. 

[samanvi]

This helps.

Added the statement -> 

 CONOPTS ='client_session_keep_alive=True' in the  libname snowflake connection and issue is resolved.

[SASKiwi]

I suggest you discuss your issue with your Snowflake DBA to see if there are any timeout settings for database connections. If there is a hard setting in Snowflake then that's the only place it can be changed.