Whenever a client application establishes a new connection to Snowflake, the user is prompted for authentication. If the client application establishes a connection multiple times, this can result in multiple prompts for authentication.

The account administrator can enable connection caching to minimize the number of times a user is prompted for authentication. When connection caching is enabled, the client application stores a connection token for use in subsequent connections.

To enable connection caching:

Set the account-level parameter ALLOW_ID_TOKEN to true:

alter account set allow_id_token = true;

For more information refer- https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-use#using-connection-caching-to-minimize-the-number-of-prompts-for-authentication-optional