You can create a private key to login to Snowflake. This is described in the Snowflake documentation, but this article highlights the important steps. Specially the generation of private key file must use the correct algorithm to work with Java.


To generate the private and public key (password protected) you may use openssl and the following commands:

openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -v1 PBE-SHA1-RC4-128 -out rsa_key.p8
openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub


Add the public key to Snowflake using ALTER USER command:

alter user jsmith set rsa_public_key='MIIBIjANBgkqh...';

The private kay file and passphrase should be added as the driver properties private_key_file and private_key_file_pwd in DbVisualizer:


Note: If account name is wrong you will get a somewhat misleading error "Incorrect username or password was specified". You should remove or correct the account name. You may also set the role using Connection Hooks or the driver property role.