topic Re: Auth Error Snowflake in SAS Programming

Auth Error Snowflake

samanvi — Thu, 14 Dec 2023 17:28:48 GMT

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.

Re: Auth Error Snowflake

SASJedi — Thu, 14 Dec 2023 18:53:43 GMT

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.

Re: Auth Error Snowflake

SASKiwi — Thu, 14 Dec 2023 19:01:02 GMT

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.

Re: Auth Error Snowflake

samanvi — Mon, 18 Dec 2023 12:48:14 GMT

This helps.

Added the statement ->

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