For TCI applications that use the Flogo Connector for Snowflake activities like "Snowflake Query", "Snowflake Insert", "Snowflake Update".
If the application has no query for 4 hours, and then there is a new request sent to the Snowflake, the request could fail.
 

Product: TIBCO Flogo Connector for Snowflake Version: 1.0 OS: Cloud

This issue happens usually because the CLIENT_SESSION_KEEP_ALIVE parameter on the Snowflake server has the value as FALSE.
When the CLIENT_SESSION_KEEP_ALIVE parameter is FALSE (default value), it requires re-login to the snowflake database after 4 hours of inactivity whereas when the value of this parameter is TRUE, Snowflake keeps the session active indefinitely as long as the connection is active, even if there is no request from the client.

The user could run "show parameters;" on the Snowflake worksheet to show the value of CLIENT_SESSION_KEEP_ALIVE.

If the value of CLIENT_SESSION_KEEP_ALIVE is FALSE, the user could run the below query to change it to TRUE:

ALTER USER <username> SET CLIENT_SESSION_KEEP_ALIVE = true
 

TIBCO Flogo Connector for Snowflake could fail after 4 hours of inactivity

WISNFK-114
WISNFK-115