SnowflakeRESTSQL Connector problem with Key-Pair Authentication
0
I am attempting to connect Mendix to Snowflake using Key-Pair Authentication (JWT) but consistently receive a 401 Unauthorized response with the body {"code": "390144", "message": "JWT token is invalid"}. I was provided by 2 keys from Snowflake admin: public and private keys, .pub and .pem respectivelly. However, SnowflakeRestSql requires .p8 format ofprivate key. So i converted my .pem file to .p8, then I have verified that my Private Key (.p8) mathematically matches the Public Key uploaded to the Snowflake user(provided by Snowflake admin). The issue persists even when testing via a Python script. By entering a new generated .p8 key, it could generate a token, but cannot access the Snowflake by this token to execute SQL command. I also tried to check the account details, but nothing helps.