Page History

...

• authenticator = SNOWFLAKE_JWT

  • Set either in the snowsql.conf file or as a command line parameter.

  • Set via RED - can Can not be set in RED.

• private-key-path = Path to private key file.

  • Set in the snowsql.conf file, as a command line parameter.

  • Set via RED - can Can not be set in RED.

• private_key_passphrase = passphrase for protected private key file [required when private key is protected]

  • Set by environment variable only SNOWSQL_PRIVATE_KEY_PASSPHRASE

  • Set via RED - can Can not be set in RED OOTB, but can be set via HSL command-line hack.

• username = Snowflake User.

  • Set either in the snowsql.conf file, as a command line parameter or environment variable.

    • RED currently uses the environment variable method.

  • Set via RED - you can use the normal “Username” field in your connections.

...

Add these snowsql.conf entries at the default level (or under a named connection):

accountname = my_org 
username = my_user_name 
authenticator = snowflake_jwt 
private_key_path = C:\Users\Administrator\snowflake_rsa_key.p8

...