Authentication token has expired. The user must authenticate again.
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.
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.