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. 

[MiguelangelC]

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