Authentication token has expired. The user must authenticate again.

run_mkay_01

When I used to run tables consisting of huge datasets it usually takes longer duration to compute.
When a single recipe exceeds 5hrs, I get this token expired error and the job fails.
Do we have some solution to exceed out run duration.

Miguel Angel

Hi,

That expiration count is coming from the database. Snowflake sessions obtain a Master Token that is good for 4 hours by default (From the message I assume is Snowflake, please correct me otherwise).

Please try the following:

1. Add the CLIENT_SESSION_KEEP_ALIVE -> true property to the Advanced JDBC properties of the database connection in Administration > Connections and save the connection.
2. Rerun the affected job
3. If the job fails again in the same manner, we'd need a job diagnosis to investigate further.

Best regards,

Miguel