You finally made the decision to utilize User KeyPair Security for your Snowflake Connections.

First you updated your Qlik Sense connections and that was a breeze. You simply clicked File, and browsed for your Private Encrypted Key File (.P8). You input the passphrase for it and you were up and running in no time. 

Now you are trying to migrate the Snowflake connector(s) you have for your Qlik Application Automations. 

You see the note that if you are switching to Key Pair Authentication instead of using your user password you should use the Decryption Passphrase. Whew! Good thing you have that stored somewhere. You copy/paste it from your list of 84,393 other vital passwords.

Your eyes scroll down on the inputs and you see "keyfile." 

You find your file, and then type in the path since there is no browse button like the Qlik Sense Snowflake Connector provides. 

You press Save and it tells you that the Connection is Linked. Well that was easy. 

You go ahead and run your Qlik Application Automation just to be sure ... Oh No! You won't get that 3 hour lunch you were planning on taking. 

Not the first time in your career you completed ignored the fine print that was staring at you on the screen. While Qlik Sense allowed you to browse to the file, and just shows you the file name, with Qlik Application Automation you need to actually open the file, copy and then paste the contents of your private key as the input. 

It may be a little confusing because it is very hard to articulate exactly what to copy/paste. If you just read the fine print, you might go out looking in your directory for a .PEM extension file. When you don't find one, you might search for P8 and PEM ... and the internet, or some Generative AI chatbot, will happily provide the instructions for how to generate a PEM extension file from a Private Encrypted Key (P8) extension file. 

What's important to understand is that if you followed Snowflake's directions to establish your Key Pair security for users, and I'm sure you did, your Private Key.P8 file will already be in the PEM format. 

Thus, the contents of the "rsa_private_key.p8" (in my case) is exactly what I need to input. You may have named yours exactly as suggested by Snowflake "rsa_key.p8"

Simply open the file using Notepad or similar editor and copy all of the contents. Including the very top: 

-----BEGIN ENCRYPTED PRIVATE KEY-----

And the very bottom:

-----END ENCRYPTED PRIVATE KEY-----

And paste the entire contents into the "keyfile" entry box:

Intentionally clipped 

Success for me and hopefully for you.