Hi,
I am trying to connect to To Snowflake database from ignition using JDBC driver connection and encrypted key - passphrase method and getting incorrect username. this is the connection URL I specified both in driver and in connection.
jdbc:snowflake://snowflakeAccount/?user=YOUR_USERNAME&authenticator=snowflake_jwt&private_key_file=/path/to/rsa_key.p8&private_key_file_pwd=YOUR_KEY_PASSWORD&warehouse=YOUR_WAREHOUSE&db=YOUR_DATABASE
and this is my connection parameters:
authenticator=snowflake_jwt
private_key_file=MY_KEY_PATH
private_key_file_pwd=MY_KEY_PASSWORD
CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX=TRUE
Any ideas how to play this around?