KB487029: "JWT token is invalid" error appear when connecting to a Snowflake database with Key Pair authentication

Symptom

After configuring Key Pair authentication in Strategy to connect to a Snowflake database, the following error appears when trying to establish the connection:

Error in accessing information from the external data source (Database Instance: (DataImport), Error: JdbcConnectionWrapper::Connect failed. 

Error type: Jdbc error. Jdbc operation attempted: Connect. [08001:390144: on SQLHANDLE] JWT token is invalid.

 

Cause

One possible cause for this issue is that the Database Login in Strategy is using a username that does not match the name of the Snowflake user.

Action

Edit the Database Login of your database instance in Strategy, and make sure the user matches the Snowflake user. The password field is not relevant as it will not be used for the connection.