Qlik Talend Snowflake Job is failing with error "Session no longer exists. New login required to access the service."

[Brian_Chan]

A Talend Snowflake Job is failing at the t<DB>Connection component when acquiring the connection to execute sql.  

The following error looks like below:

Getting the "Session no longer exists. New login required to access the service."

Resolution

Comparing both Timeout settings within Talend Studio and Snowflake

• In Studio -->Navigate to the snowflake connection component > Advanced Settings > Login Timeout 
• In Snowflake -->SHOW PARAMETERS LIKE '%timeout%';

Cause

The Snowflake or Talend Studio Snowflake component Login Timeout may have been set too low for what was required

Environment

• Talend Studio 
• Talend Data Integration